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
Plz can any one say me how to get the informatica certification materials and dumps
wf dont have integration severances how you can run?
Which version configuration tool used in ur project?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
can anyone explain me about retail domain project in informatica?
What are different types of transformations available in informatica?
How can we improve session performance in aggregator transformation?
What are the advantages of informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
What are pre and post-session shell commands?
what are the deliverables?in your project?
What is the fact table?
What is joiner transformation?
What is rank index in rank transformation?
What are the limitations of joiner transformation?