How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answer Posted / g. manthiramoorthy
Create Two Port in Exp. Trans
v_temp : v_temp+1
o_seq : IIF(ISNULL(v_temp),0,v_temp)
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Reusable transformation and shortcut differences
what are the deliverables?in your project?
Informatica settings are available in which file?
How are indexes created after completing the load process?
What is pmcmd command?
What is rank transformation?
What is the difference between stop and abort in informatica
Is it possible to create multiple domains on a single Informatica server?
What do you understand by a term domain?
What is incremental aggregation?
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
have u done any performance tuning? how u ll do?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com