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 / singam srini
Hi
who replied the answer to given qs.. they were wrong..
please read the qs properly then reply ok..
sameer said same sequence generator..
deepak said reusable transformation(seq gen) and mappet..
how can we implement same seq gen t/r in different repositories..?
is it possible..?
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a router transformation?
How is union transformation utilized?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Suppose we do not group by on any ports of the aggregator what will be the output?
What is data transformation manager process?
What is rank transform?
What are the components of workflow manager?
How to elaborate powercenter integration service?
What are the data movement modes in informatica?
What is dimensional table? Explain the different dimensions.
What are the types of lookup transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what is INFORMATICA TESTING process