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
How to generate or load values in to the target table based on a column value using informatica etl tool.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the main issues while working with flat files as source and as targets ?
what is the difference between informatica6.1 and infomatica7.1
What is a joiner transformation and why it is an active one?
Which transformation is needed while using the Cobol sources as source definitions?
What is exclusive and normal mode for repository services?
how tokens will generate?
What are the issues you have faced in your project? How did you overcome those issues?
What all are steps in up gradation of Informatica server?
How do you set a varible in incremental aggregation
Why union transformation is an active transformation?
How we can create indexes after completing the load process?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is dimensional table? Explain the different dimensions.