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 are the static cache and dynamic cache in informatica?
What are roles and groups and benefits of using them?
Can you generate sequence numbers without using the sequence generator transformation?
Mention few power centre client applications with their basic purpose?
What are the components of workflow manager?
How to extract the informatica rejected data?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is sequence generator transformation in informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are the popular informatica products?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the maplet?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What all join we can perform in LOOKUP transformation?
What are the transformations that are not supported in mapplet?