Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4763 Views
- TCS, I also Faced
- E-Mail Answers
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
How to improve the performance of a session using sorter transformation?
What are the different options available for update strategy?
How to convert multiple rows to single row (multiple columns) in informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What does role playing dimension mean?
COM components can be used in Informatica
What is sequence generator transformation in informatica?
What is a router transformation?
What are junk dimensions?
What differs when we choose the sorted input for aggregator transformation?
How might one distinguish in the case of mapping is right or not without associating session?
What is dynamic cache?
How union transformation is used?
How to create Target definition for flat files?
wf dont have integration severances how you can run?
