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
- 4046 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 |
What are the types of lookup?
wat s mapping parameter and mapping variable? how do you set that in a mapping?
What is the role of informatica in project ?Like i showed financial projects?
What are the challenges of Dataware housing in the future?
Enlist the various types of transformations.
can you please explain me pre session and post session options?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
What r the type of indexes u generally used in informatica?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
how can u avoid duplicate rows in flat file?
In any project how many mappings they will use(minimum)?
To import the flat file definition into the designer where should the flat file be placed?
Teradata 
