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 / 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
Could you explain what is enterprise data warehouse?
what are the deliverables?in your project?
What are the prerequisite tasks to achieve the session partition?
What is dynamic cache?
What are the types of schemas we have in data warehouse and what are the difference between them?
How many types of sessions are there in informatica.please explain them?
What is an Integration service in Informatica?
server hot-ws270 is connect to Repository B. What does it mean?
Mention few power centre client applications with their basic purpose?
What is option by which we can run all the sessions in a batch simultaneously?
What if the source is a flat-file?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
difference between informatica 8.1.1 and 8.6
What are the transformations that are not supported in mapplet?
What is a passive transformation?