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
- 4304 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 |
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
what is parallel querying and what r hints.
what is surrogate id ?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
How to create or import flat file definition in to the warehouse designer?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is olap (on-line analytical processing?
how to duplicates from expression transformation without using sorter before that
If I am having 6 flat files in data. How can you load the data at a time
When we are using Dynamic Cache,which options we will select in session level?
Teradata 
