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
- 14947 Views
- Barclays, I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
Hi Sameer.
Thanks for the reply.
Can we use same sequence generator across different repositories?
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
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 ?
How to generate or load values in to the target table based on a column value using informatica etl tool.
what are factless facts? And in which scenario will you use such kinds of fact tables.
how to load dimension table and fact table. plz tell me the steps.
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 are the new features of Power Center 5.0?
What is rank transform?
How to generate sequence numbers using expression transformation?
r u done any partitions in ur project?
Could you explain what is enterprise data warehouse?
Explain the types of transformations?
Why is sorter an active transformation?
without table how to come first record only in oracle?
Explain load alternative records / rows into multiple targets - informatica
What does “tail –f” command do and what is its use as an Informatica admin.
