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 |
what is constraint based loading
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What does update strategy mean, and what are the different option of it?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
What is galaxy shema
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
Where can we find the throughput option in informatica?
how to calculate the optimum cache size in aggregator transformation?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
What is a unit Testing?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?