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
Answer Posted / harleen
This is the case that we use for audit balancing in our project.
At the starting of the session have the source count and checksum of a field and write it into a file.After the load is done in target count the number of rows in the target and write the values in a file.After the target load session is over,use command task and have a script that compares the two scripts.If the count matches scripts succeeds else fails.In assignment link give condition that session.status =SUCCEEDED then first workflow and session.status-FAILED hen second workflow
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explian the Process of deployment groups in informatica
What you know about transaction control transformation?
What is rank transform?
What does reusable transformation mean?
How does the aggregator transformation handle null values?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is difference between a gateway node and worker node?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the difference between a connected look up and unconnected lookup?
Define update strategy?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
what is index?how it can work in informatica
What is a rank transform?