Interested to Buy Any Domain ? << Click Here >> for more details...
How could we generate the sequence of key values without
using sequence generator transformation in the target ??
- 12 Answers
- 37720 Views
- TCS, Tech Mahindra, I also Faced
- E-Mail Answers
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 are the sources and targets definitions imported in informatica designer?
Explain the scenario which compels informatica server to reject files?
How can repository reports be accessed without sql or other transformations?
can you please explain me pre session and post session options?
What is sequence generator transformation in informatica?
Can you use flat files in Mapplets.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Make a note of the quantity vaults made in informatica?
How you can differentiate between connected lookup and unconnected lookup?
whats the logic to load the lower level of granularity of data to fact table.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Define Pmrep command?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the features of complex mapping?
What are the static cache and dynamic cache in informatica?
