In a concurrent batch if a session fails, can you start again from that session
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
how DTM buffer size and buffer block size are related
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
State the limitations where we cannot use joiner in the mapping pipeline?
Explain the flow of data in Iinformatica?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
How many transformations can be used in mapplets.
What are the Differences between static cache and dynamic cache?
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?