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
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How do you handle two sessions in Informatica
How to open an older version of an object in the workspace?
How to generate sequence numbers using expression transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How do you load only null records into target?
Explain the use of aggregator cache file?
Sequence generator, when you move from develoment to production how will you reset
How do you manage the Parameter files while migrating your data from one environment to another environment?
How can we delete duplicate rows from flat files?
What is an aggregator transformation?
Explain the scenario which compels informatica server to reject files?
What is a repository? And how to add it in an informatica client?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?