How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answer Posted / arnab
either use oracle to generate the sequence number or use an
unconnected lkp transformation which looks up on the
target, get the max(value) of the column which has to be
incremented and increment the value by 1
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain sessions?
What all are steps in up gradation of Informatica server?
What is intricate mapping?
How can you generate reports in informatica?
What are the different ways to implement parallel processing in informatica?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is DR strategy for Informatica project?
Define Pmrep command?
Difference between Target-based loading and constraint-based loading?
Could you explain what is enterprise data warehouse?
Target increases every day even though no new record was inserted
If informatica has its scheduler why using third party scheduler?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?