How could we generate the sequence of key values without
using sequence generator transformation in the target ??

Answer Posted / sathish

use expression transformation
create two ports
one is assigned with it to zero
another one is assigned in outputport with expression logic
is o_seq=v_seq+1;

Is This Answer Correct ?    9 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Under what condition selecting sorted input in aggregator may fail the session?

666


Explain target update override in informatica

631


Explain dynamic target flat file name generation in informatica

651


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

632


What is difference between a gateway node and worker node?

628






How to Create a folder using pmrep command?

626


How can we create index after completion of load process?

600


How does the aggregator transformation handle null values?

702


How can you generate reports in informatica?

581


In informatica workflow manager, how many repositories can be created?

783


What is rank transform?

603


What will be the approach?

582


Did u used latest transformations of 8.6.0? for what?

1481


What are the components of Informatica? And what is the purpose of each?

624


What are the tasks that can be performed using sq?

615