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 the mapping variable usage example in informatica
scenario where i can use only concurrent execution of workflow.
Briefly explain the aggregator transformation?
What is deployment group?
What is mapplet in informatica?
can anyone explain me about retail domain project in informatica?
What do you understand by term role-playing dimension?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is Data Caches size?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How to extract sap data using informatica?
How to load data in informatica ?
Why do you use Mapping Parameter and mapping variable?
How to use procedural logic inside infromatica?
What are Dimensional table?