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
- 4659 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
What are the different ways to implement parallel processing in informatica?
How does the aggregator transformation handle null values?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the restrictions of union transformation?
How to elaborate tracing level?
What is aggregate cache in aggregator transformation?
Explain about Informatica server process that how it works relates to mapping variables?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is status code in informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are different types of transformations available in informatica?
tell me 5 session failure in real time how can you solve that in your project?
design of staging area?
In development project what is the process to follow for an etl developer from day1
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
