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


Please Help Members By Posting Answers For Below Questions

How to generate or load values in to the target table based on a column value using informatica etl tool.

854


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6465


What are the main issues while working with flat files as source and as targets ?

943


what is the difference between informatica6.1 and infomatica7.1

1939


What is a joiner transformation and why it is an active one?

797


Which transformation is needed while using the Cobol sources as source definitions?

969


What is exclusive and normal mode for repository services?

923


how tokens will generate?

1968


What are the issues you have faced in your project? How did you overcome those issues?

2108


What all are steps in up gradation of Informatica server?

837


How do you set a varible in incremental aggregation

1672


Why union transformation is an active transformation?

864


How we can create indexes after completing the load process?

952


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2219


What is dimensional table? Explain the different dimensions.

939