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
- 12653 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
in reporting we add some new objects,how we get the count of the newly added objects to the report
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are connected or unconnected transformations?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
lookup transformation with screenshots
How can you validate all mappings in the repository simultaneously?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
differences between service based and product based?
what is diff b/t sorter t/r and agg have the option sorter property...
What are the different versions of informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Why do we need informatica?
What is meant by active and passive transformation?
On which transformations you created partitions in your project?
What is powercenter on grid?
