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

Under what condition selecting sorted input in aggregator may fail the session?

874


As union transformation gives UNION ALL output, how you will get the UNION output?

873


What is a repository manager?

863


Define update strategy?

827


How to call shell scripts from informatica?

767


What do you mean by channel change?

761


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5706


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1406


What is blocking transformation?

913


What is the difference between a repository server and a powerhouse?

1161


Differentiate between Load Manager and DTM?

1887


Clarify the utilization of aggregator cache record?

774


Whats the difference between informatica powercenter server, repositoryserver and repository?

932


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1672


What are the new features of informatica 9.x at the developer level?

825