How can i maintain unique surrogate key if 2 seperate
workflows from different repository run and insert/update the
main table at the same time.
Answer Posted / deepak
Create a sequence generator transformation in transformation developer and use this transformation instead of using separate sequence generators. 2. Use mapplet and design
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain the scenario which compels informatica server to reject files?
Under what condition selecting sorted input in aggregator may fail the session?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
I have a flat file, want to reverse the contents of the flat file
How to create or import flat file definition in to the warehouse designer?
What are session parameters ? How do you set them?
What are active transformations.
EXL informatica Questions
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is a sequence generator transformation?
What is sq transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Informatica Checkpoints