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
- 4663 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 |
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
where is the reject loader .
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How can yoU improve session performance in aggregator transformation?
What is informatica? What exactly are the practical uses in real world
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
how can we check whether a particular cache is static or dynamic?
what are the different types of transformation available in informatica and what are the mostly used ?
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
What is degenerated dimention table?
What are the phases in SDLC?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
Teradata 
