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
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are junk dimensions?
While migrating the data from one environment to another environment how would you manage the connections?
What is the use of transformation?
What is the use of source qualifier?
State the limitations where we cannot use joiner in the mapping pipeline?
How many ways are there to do 'remove duplicate records in informatica'?
how we can load rejected record's at run time?(not through bad files)
What is joiner change?
Make a note of the quantity vaults made in informatica?
What are data-driven sessions?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is meant by pre and post session shell command?
Quickly characterize reusable change?
What is a joiner transformation and why it is an active one?