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


Please Help Members By Posting Answers For Below Questions

What do think which one is the better joiner or look up?

722


design of staging area?

1585


In warehouses how many schemas are there?

580


Informatica settings are available in which file?

585


scenario where i can use only concurrent execution of workflow.

2536






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)

1075


Quickly characterize reusable change?

687


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1525


How can informatica be used for an organization?

649


What is parallel processing in informatica?

1023


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.

630


Explain sessions?

602


How do we call shell scripts from informatica?

593


What is Session and Batches?

660


draw informatica architecture 8.6 ?

3468