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
- 9266 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
waht type of interface is used for testing the data in informatica
What is fact table? Explain the different kinds of facts.
Explain transaction control transformation in informatica
how to load rows into fact table in data warehouse
What is flashback table ? Advance thanks
Under which circumstances, informatica server creates reject files?
Slowly changing dimensions, types and where will you use them
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How an expression transformation differs from aggregator transformation?
What is intricate mapping?
What will be the approach?
What is the function of look up transformation?
How to elaborate powercenter integration service?
What is a filter transformation?
What is informatica metadata and where is it stored?
