How to identify this row for insert and this row for update
in dynamic lookup cache
- 3 Answers
- 8819 Views
- CSC, I also Faced
- E-Mail Answers
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 |
How to generate a single mapping for both the historical and incremental load.
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
What is pmcmd command?
How can i set break points in debugging mode ? can explain steps please?
What are set operators in Oracle
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
How do you load only null records into target?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
How to display First letter of Names in Caps?
Teradata 
