2,can we insert duplicate data with dynamic look up cache,if
yes than why and if no why?
Answers were Sorted based on User's Feedback
Answer / ankur saini er.ankur861@gmail.
we use dynamic lookups in case we have duplicates in source
and source says that they cnt remove them as per
requirement ...in that case we have to settle for:
say we have a reocrd id=1 , name=a
id=1 , name=b
so depending upon the PI id this is a duplicate so using
dynamic lookup when firts record comes the lookup cache
will have id=1 , name=a
again will duplkicate row will come then it gets updated to
id=1 , name=b
so finally only last record from the quplicates will be
lloaded in the target
Is This Answer Correct ? | 2 Yes | 0 No |
How do you remove duplicate records in informatica? And how many ways are there to do it?
Limitation of REPLACESTR. Is there any character limitation to it.
How would you copy the content of one repository to another repository?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
What is dynamic cache?
Why we use partitioning the session in informatica?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is confirmed dimension?
How to load last n records of file into target table - informatica
What are the different versions of informatica?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
how to use incremental load?