hi, kalyan can u write that query in sql override.

How could we generate the sequence of key values without
using sequence generator transformation in the target ??

Question Posted / nagaraj

Answer Posted / nagaraj

hi, kalyan
can u write that query in sql override.

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Why do we need informatica?

936

what is the Default Source Option For Update Strategy Transformation?

1181

When do you use sql override in a lookup transformation?

1038

Is it possible to define a single node as a Gateway node as well as worker node?

1072

What is blocking transformation?

1088

What is a repository? And how to add it in an informatica client?

1097

can anyone explain me about retail domain project in informatica?

7901

What is meant by incremental aggregation?

1038

explain abt ur project architecture?

2129

What do you mean by channel change?

981

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1906

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1213

What is standalone command task?

1276

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

927

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7341