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 are the different types of transformation available in informatica. And what are the mostly used ones among them?
HOW TO GET THE LATEST DATA IN SCD ?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
Slowly changing dimensions, types and where will you use them
I have a flat file, want to reverse the contents of the flat file
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
How to do unit testing in informatica? How to load data in informatica ?
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
How does the server recognize the source and target databases. Elaborate on this.
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
WAT IS TEXT LOAD?