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
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 |
how to call lookup qualifer in unconnected look;up
WHat all joins are there in Source Qualifier?
How can you define a transformation? What are different types of transformations in Informatica?
enterprise datawarehouse your project phase by phase explain?
Which one is better performance wise connected/un-connected lkp?why?
Explain what transformation and how many are there in informatica?
how the server recognises , if the session fails after loading the 100 records in to the target
what is worklet and what use of worklet and in which situation we can use it?
How to do the error handling of if ur source is flatfiles?
Sequence generator, when you move from develoment to production how will you reset
What is data caches/ index caches?
How is Data Models Used in Practice?