what is the significance of newlookup port in dynamic look up
Answer Posted / suraj kedia
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 |
Post New Answer View All Answers
What is deployment group?
Can we create two repositories on same database instance in oracle?
Why sorter is an active transformation?
How does a sorter cache works?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Which development components of informatica have the highest usage?
Write the unconnected lookup syntax and how to return more than one column.
How do you manage the Parameter files while migrating your data from one environment to another environment?
In which transformation you cannot drag ports into it?
how to create user defined function (udf) in informatica
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain the types of lookup transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
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
How do you load only null records into target?