How to identify this row for insert and this row for update
in dynamic lookup cache
Answers were Sorted based on User's Feedback
Answer / kish
Hi Based on NEW LOOKUP ROW..informatica server indicates
which one is insert and which one is update.
New lookup row=0...no change
1....Insert
2....update
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / krish
0 The PowerCenter Server does not update or insert the row
in the cache.
1 The PowerCenter Server inserts the row into the cache.
2 The PowerCenter Server updates the row in the cache.
| Is This Answer Correct ? | 6 Yes | 3 No |
can we load the data with out a primary key of a table? what is target plan?
checkout and checkin in informatica 8.6
Router T/R is active but some people are saying it is also passive which is exactly right?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
What are the active and passive transforamtions?
what are the limitation of sorter transformation?
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
How will u find weather dimension table is big in size of a fact table?
What are the Differences between static cache and dynamic cache?
Difference Between ETL & ELT?
What is a unit Testing?
How to do unit testing in informatica? How to load data in informatica ?