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
- 4075 Views
- TCS, I also Faced
- E-Mail Answers
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 |
which one is better performance wise joiner or look up
Target increases every day even though no new record was inserted
What aer the out put files that the informatica server creates during the session running?
what is lookup ?
What is degenerated dimention table?
without matching columns in two tables. how can you join
What are the types of caches in lookup?
WHAT IS FACT TABLES?
any body can say about all versions of informatica ?how many versions ?
What are the types of data that passes between informatica server and stored procedure?
Explain scd type 3 through mapping.
If we set dd_insert in mapping and Delete in session properties what will happen.?
Teradata 
