Describe two levels in which update strategy transformation
sets?
Answer / swetha
Within a session. When you configure a session, you can
instruct the Informatica Server to either treat all records
in the same way (for example, treat all records as inserts),
or use instructions coded into the session mapping to flag
records for different database operations.
Within a mapping. Within a mapping, you use the Update
Strategy transformation to flag records
| Is This Answer Correct ? | 7 Yes | 2 No |
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
What is domain and gateway node?
How will the document be delivered to me?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
In Which scenario did u used Incremental loading?
What is the advantage of informatica?
explain about informatica server architecture?
What are the types of lookup?
Is there any model difference between ODS and DWH
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?