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
What happens when a session fails and you click on recover?
What are the differences between oltp and olap?
tell me 5 session failure in real time how can you solve that in your project?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Enlist the differences between database and data warehouse.
How to handle decimal places while importing a flatfile into informatica?
What is the command used to run a batch?
What are the new features of informatica 9.x developer?
Where are the source flat files kept before running the session?
Parameter and variable differences
How to improve the performance of a session using sorter transformation?
How might you approve all mappings in the archive all the while?
Explain Dataware house architecture .how data flow from intial to end?
Enterprise data warehouse your projects phase by phase explain?
What are the different options available for update strategy?