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 |
if soource is having 10 records how will u insert 20 records to target
diffrence between command task and control task
What are Rapid changing dimensions?
how can we perform incremental aggregation?explain with example?
What are the different versions of informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
can we have to do changes in session property when we are dynamically generating target files?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Please let me know how to make Data masking in informatica..
Can you use one mapping to populate two tables in different schemas
How do you convert single row from source into three rows into target?