i have source file data empno,ename,sal 100,ram,1000
200,tyu,2000 300,gh,3000 out put as e
empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

Answer Posted / ravi

logic IS GREAT.
BUT, HOW INTEGRATION SERVICE INITIALIZES V_COUNT AS '0' , SO
THAT V_COUNT+1 RETURNS '1'?

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Target increases every day even though no new record was inserted

1191


What is fact table? Explain the different kinds of facts.

672


What are the main features of Oracle 8i with context to datawarehouse?

1747


What is intricate mapping?

658


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2479






What is InformaticaPowerCenter?

765


Explain the use of aggregator cache file?

762


Can anyone tell me the new features in Informatica 9 Version?

1592


How do you change a non-reusable transformation to reusable transformation?

664


What do you understand by a term domain?

740


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

711


Explain in detail about scd type 1 through mapping.

660


How are the sources and targets definitions imported in informatica designer?

746


State the limitations where we cannot use joiner in the mapping pipeline?

614


What are the different options available for update strategy?

635