Interested to Buy Any Domain ? << Click Here >> for more details...
How to identify this row for insert and this row for update
in dynamic lookup cache
- 3 Answers
- 9297 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 |
Describe data concatenation?
how to delete duplicate records by using filter transfermation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
What are the ETL tools available in DWH?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
What is the difference between a shortcut of an object and copy of an object? Compare them.
How to load query faster,so that It will take less time to load?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
Explain dynamic target flat file name generation in informatica
Which transformation is needed while using the Cobol sources as source definitions?
Teradata 
