How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answer Posted / sathish
use expression transformation
create two ports
one is assigned with it to zero
another one is assigned in outputport with expression logic
is o_seq=v_seq+1;
| Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
What are the different types of transformation available in informatica.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
In informatics server which files are created during the session rums?
What is informatica powercenter repository?
Differentiate between Load Manager and DTM?
What is rank index in rank transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the issues you have faced in your project? How did you overcome those issues?
Differentiate between a database and data warehouse?
What is a mapplet/worklet in informatica?
Can we create a Integration service without a Repository service and vice versa?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What the difference is between a database, a data warehouse and a data mart?
What are the different ways to implement parallel processing in informatica?
Explain the types of lookup transformation?