what is the significance of newlookup port in dynamic look up
When we configure a look up t/r to use a dynamic cache, the
designer automatically adds a port called "New Lookup Row"
to the look up t/r. This port indicates with a numeric value
whether the Informatica server inserts or updates the row in
the cache or makes no change in the cache.
To keep the lookup cache and the target table
synchronised, we pass rows to the target when the New Lookup
Row value is equal to 1 or 2.
Is This Answer Correct ? | 5 Yes | 0 No |
what is difference between dimention table and fact table?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
my source is junk data how will u remove that junk data by using unix please any one replay me
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
What is query panel?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is an unconnected transformation?
what is row level and column level indicator?
What do you mean by worklet?
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
What is meant by a domain?
What is meant by lookup transformation? Explain the types of lookup transformation?