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
Target increases every day even though no new record was inserted
What is fact table? Explain the different kinds of facts.
What are the main features of Oracle 8i with context to datawarehouse?
What is intricate mapping?
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?
What is InformaticaPowerCenter?
Explain the use of aggregator cache file?
Can anyone tell me the new features in Informatica 9 Version?
How do you change a non-reusable transformation to reusable transformation?
What do you understand by a term domain?
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?
Explain in detail about scd type 1 through mapping.
How are the sources and targets definitions imported in informatica designer?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the different options available for update strategy?