Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4764 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 |
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
How to do Integration testing in Informatica?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
What are the different components of powercenter?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
What is a transaction control transformation?
difference between repository database and repository service?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
what is the incremental agrrigation?
Can we run session without using workflows?
Teradata 
