Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 9 Answers
- 14988 Views
- Barclays, I also Faced
- E-Mail Answers
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
What is the benefit of partitioning a session?
To import the flat file definition into the designer where should the flat file be placed?
EXL informatica Questions
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is meant by a domain?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is lookup transformation?
Can you generate sequence numbers without using the sequence generator transformation?
Explain in detail about scd type 1 through mapping.
Define filter transformation?
What are the types of data warehouses?
What is the status code in stored procedure transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
As union transformation gives UNION ALL output, how you will get the UNION output?
What is sorter transformation?
