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
Which transformation is needed while using the Cobol sources as source definitions?
What is informatica metadata and where is it stored?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
In informatica workflow manager, how many repositories can be created?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the issues you have faced in your project? How did you overcome those issues?
Define mapplet?
Differentiate between reusable transformation and mapplet.
If informatica has its scheduler why using third party scheduler?
Describe expression transformation?
Tell me about MD5 functions in informatica
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What do you understand by term role-playing dimension?
What you know about transaction control transformation?
What is InformaticaPowerCenter?