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


Please Help Members By Posting Answers For Below Questions

Explain the mapping variable usage example in informatica

862


scenario where i can use only concurrent execution of workflow.

2801


Briefly explain the aggregator transformation?

790


What is deployment group?

892


What is mapplet in informatica?

780


can anyone explain me about retail domain project in informatica?

7707


What do you understand by term role-playing dimension?

786


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1043


What is Data Caches size?

839


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

894


How to extract sap data using informatica?

804


How to load data in informatica ?

775


Why do you use Mapping Parameter and mapping variable?

1484


How to use procedural logic inside infromatica?

859


What are Dimensional table?

805