วีดีโอ

for suppose if i get a value in csv like phone.no1^phone.no2 and in targer we have only one column called target.no. is it possible to transform and send each phone no separate? instead of 1 outcome, basically i need in C360 phone Array(2) and each array i need each phone number.

im getting error : Object is not valid: java.rmi.RemoteException:String index out of range: 0; nested exception is: com.informatica.saas.common.exception.SaasExceltion: String index out of range 0: 0..

Hi sir can u please do one mini project end to end for iics and explain the flow it will be very helpfull for interviews

Can u Explain what are the Challenges are we faced in IICS wen compared to IPC?

Thanks for the video sir, i have one doubt regarding update option in definition , whenever i select update and cant update columns in Schedule option.? But the data has been updating ..

Hii.....how to trigger tommorow files automatically...for example I have a file called 07-11-2024_orders.csv and run this today's file and scheduled for tommorow...and tommorow automatically triggered tommorows file like 08-11-2024_orders.csv...how to solve this..this was asked in an interview

Great! thanks for this great tutorial

Can u pls share few videos in data object parameterization

Great job But I want to load data from Oracle to JSON file (or) MongoDB collection so Can you make a video ?

can synchronization task allow the user to perform sorting , filtering ,aggregation or joining?

How can we parameterize the schema name in this?

You selected only country cd as return port in lookup but why in target both columns are showing???

Need to know how Exclude work in expression.. pls tell us

Hello sir could please explain task flow parameter (contant,field,formula)

Please let me know how to migrate the jobs from datastage etl tool to iics

Dach Well

Thank you so much❤

There is an update, to make it a single tag in XML or Json we have an option in Hierarchy Builder's output settings. select the generate the single output option. We dont need to take the dummy source and all.

Hi Roshan, How to load first record into table A, last record to table B and remaining records to table C

Hi can we replicate or copy data from local storage like linux to azure blob or adls?

Checksum without also can do it right?

Hi roshan i followed your videos in scdtype 2 with flag i have run the mapping task but i am getting error see the below "Internal error. The DTM process terminated unexpectedly. Contact Informatica Global Customer Support." please guide me

Hi Roshan, can you please guide me if IICS's Couchbase Connector has any compatibility with its version. All we need to get data extraction done from Couchbase Server but wasn't able to extract it. Would be great if you can post a sample mapping in doing so as its JSON fed DB I believe.

Intelligent structure model is not available in IICS IN Free version now under component section i tried.

hi

hi i did same process which you explain class in database i run the query i am getting no data please guide me SELECT A.EMPNO, A.ENAME, B.DEPT_ID, B.DEPT_NM, C.COUNTRY_CD FROM EMP A INNER JOIN DEPT B ON A.DEPTNO = B.DEPT_ID INNER JOIN COUNTRY_CD C ON A.COUNTRY = C.COUNTRY_CD;

So sir it means if we want scd type 1 we can use this dynamic lookup

could you provide any complex mapping for interview purpose

in this mapping what is the lookuptr which table is import it source or target please can you elaborate it

Somehow my filter condition is not working but this video is absolutely helpful. Thank you so much !

Sir Nice video❤

SABKO SNOWFLAKE BATAKE KHUD KE BHI LALWE LAGA DO.

hi i did same process but i got the error "java [ERROR] java.lang.OutOfMemoryError: Java heap space " please guide me on this error

hi i follow same process which you explain that one i was run job it is successfully but it is emp table is loaded zero records others tables like dept & salgrade loaded successfully can you guide me please what is the problem.

I got confused a lot watching this video 🙂

Excellent explanation sir. Thankyou so much!

Hi Sir, i'm attending to interviews as an ETL Developer. i was asked questions on complex mapping and transformations in iics. can u please provide me complex mapping and what are the issues we will face while developing it.

Why did you use lookup persistent cache, As it will occupy the space not delete , is there any use, if it is corrupted, how to recover

your video's not having high quality

Can we use parameters/variable in synchronisation task? If yes, please make a video on that along with to update the parameter value for incremental load.

Hello Sir, Could you please add theory at least definition before jump into the practical. it would be great if you add so people can understand why we are doing and what the use.

Hello Roshan, I told the same way when I was asked this question in an Interview .. but Interviewer asked me 2 more approaches of doing the same which I am not sure.

I tried without linking source to Sequence gen transformer and it worked for me and i disabled incoming fields.

what if the question is to get the 3rd max salary value by using sorter and aggregator tf only? how to acheive that? i got asked this scenario in one interview?

I would like to see if 2 files are arriving same time. in your example you feed 2 files but with time gap

Hi buddy, can you make one video, in which you can read data from SAP and apply filter on date column with time format possibilities? May be you can cover incremental load form SAP to any target? Thanks in advance.

to_timestamp('$Lastruntime','YYYY-MM-DD HH24:MI:SS')-6/24 in oracle it is not working and it's showing >> ERROR: Prepare failed. : [ FnName: Execute -- [Informatica][ODBC Oracle Wire Protocol driver][Oracle]ORA-00907: missing right parenthesis ]

good explanation watching from whitefiled bangalore working in one of the MNC companies