How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answer Posted / g. manthiramoorthy
Create Two Port in Exp. Trans
v_temp : v_temp+1
o_seq : IIF(ISNULL(v_temp),0,v_temp)
Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What do think which one is the better joiner or look up?
design of staging area?
In warehouses how many schemas are there?
Informatica settings are available in which file?
scenario where i can use only concurrent execution of workflow.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Quickly characterize reusable change?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How can informatica be used for an organization?
What is parallel processing in informatica?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Explain sessions?
How do we call shell scripts from informatica?
What is Session and Batches?
draw informatica architecture 8.6 ?