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
- 4210 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 is confirmed fact in dataware housing?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain the aggregator transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the guidelines to be followed while using union transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is a difference between complete, stop and abort?
What is the fact table?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is status code in informatica?
draw informatica architecture 8.6 ?
What are the static cache and dynamic cache in informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
what is the Default Source Option For Update Strategy Transformation?
