How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answer Posted / raghu
TAKE EXPRESSION TRANSFORMATION AND DOUBLE CLICK ON THE
EXPRESSION TRANSFORMATION AND ADD TWO NEW PORTS
1.SEQ
2.SEQ_OUT
1.IN THE SEQ PORT CHECK V=VARIABLEPORT THERE YOU MENTION
EXPRESSION SEQ+1.
2.IN THE SEQ_OUT PORT CHECK O=OUTPUTPORT THERE YOU MENTION
EXPRESSION IIF(ISNULL(SEQ),O,SEQ)
IT WILL GIVE CORRECT RESULT
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How to extract sap data using informatica?
Define sessions in informatica etl?
Where are the source flat files kept before running the session?
How to do the error handling of if ur source is flatfiles?
What differs when we choose the sorted input for aggregator transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is pmcmd command?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How do you take back up of repository?
What is an aggregator transformation?
How do you load only null records into target?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to load a Dimension ? and how to load a fact table?