Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 9477 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sameer
1) Connect the source Qualifier to expression transformation.
2) In the expression transformation create a variable port V_count and increment it by one.
3) Create V_sal variable port and assign the expression IIF(V_count=1,NULL,V_prev_sal) to it.
4) Create one more variable port V_prev_sal and assign Sal to it.
5) Now create output port O_prev_sal and assign V_sal to it.
6) Connect the expression transformation to the target ports.
In the expression transformation, the ports will be
empno, ename, sal
V_count=V_count+1
V_sal=IIF(V_count=1,NULL,V_prev_sal)
V_prev_sal = sal
O_prev_sal = V_sal
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are the modules in Power Center
What is dimensional table?
How to Create a folder using pmrep command?
How many number of sessions can one group in batches?
Separate from a database, an information bazaar, and an information stockroom?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Explain constraint based loading in informatica
Why filter transformation is an active one?
wat are deployement groups in informatica, how it will be used for developers
Explain pushdown optimization $pushdownconfig parameter - informatica
Differentiate between reusable transformation and mapplet.
what is Active lock explain
Explain the types of lookup transformation?
Write the advantages of partitioning a session?
Write the unconnected lookup syntax?
