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
- 4374 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
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
what is song in infrmatica...?
permutations of mapplet
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what is the -ve test case in your project.
How can we create index after completion of load process?
What is the different lookup cache(s)?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Define pmcmd command?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Why filter transformation is an active one?
What are the different versions of informatica?
what are the deliverables?in your project?
What are different types of transformations available in informatica?
Can we override a native sql query within informatica?
