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
- 4857 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
have u done any performance tuning? how u ll do?
What is data transformation manager process?
What is different between the data warehouse and data mart?
What is an aggregator transformation?
What is standalone command task?
How do you use reject loader.
How to join three sources using joiner? Explain though mapping flow.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Write the different tools in the workflow manager?
Difference between Target-based loading and constraint-based loading?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is an expression transformation?
permutations of mapplet
What is the status code in stored procedure transformation?
what is the -ve test case in your project.
