How can i generate Seqence Numbers to Tagret Table
(with out using Seqence Gen Trans,Rank Trans).
Answer Posted / krishna
Use database Sequence generator call this from stored
procedure or dummy lookup query
or
You can also use expression transformation. Create two
ports one is variable and assign it to 0 and another one is
output port ind Write the logic to increment it
(o_seq=v_Seq+1)
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How to elaborate powercenter integration service?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Explain Dataware house architecture .how data flow from intial to end?
What can we do to improve the performance of informatica aggregator transformation?
Performance tuning in UNIX for informatica mappings?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Informatica settings are available in which file?
How do you load only null records into target?
How can we remove the duplicates from flat file source?
How many ways are there to create ports?
How to join three sources using joiner?
What is a mapplet/worklet in informatica?
How to create the source and target database connections in server manager?
Explain dynamic target flat file name generation in informatica
What is the difference between a connected look up and unconnected lookup?