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
- 9491 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 |
What is data merging,data cleansing,sampling?
Where do you create/define mapping parameter and mapping variable?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
What do you mean by enterprise data warehousing?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is use of batch file in informatica? How many types of batch file in informatica?
difference between shortcut and reusable transformation?
What is the need of etl tools?
tell me 5 session failure in real time how can you solve that in your project?
Have you worked with/created Parameter file
Teradata 
