How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answer Posted / kalyan
Do a lookup on the Target table with an Lookup SQl Override
Select MAX(FIELD_NAME), field 1 , field3 from target group
by field1, field2...
In the Expression increment the Max values of the field
which you just got from the lookup by 1.
Here MAX_FIELDNAME) is the Max value of the field you want
to generate the sequence of..
Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
Explain the difference between a data warehouse and a data mart?
What are the tasks that source qualifier perform?
Write the unconnected lookup syntax?
State the differences between sql override and lookup override?
What is the difference between Active and Passive transformation?
How to generate sequence numbers?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are the different ways to implement parallel processing in informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How does a sorter cache works?
How to update a particular record in target with out running whole workflow?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Briefly explain the aggregator transformation?
Define mapplet?
What is flashback table ? Advance thanks