generate date / time dimension in informatica
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
What is target update override
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
sorce is a flatfile only 1st and last row should insert to target how will u do?
What is sql query override? When did u use sql query override?
What is data transformation manager process?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
how lookup is acting as both active and passive ? how is it possitble?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
What are the reusable transforamtions?
What is the need of building a data warehouse?