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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rsbandaru
Ok..Integration service by default assigns value 'o' to the
variable port..
Is This Answer Correct ? | 0 Yes | 0 No |
What are the components of Informatica? And what is the purpose of each?
During the running session, output files are created by informatica server. Enlist few of them.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the different types of repositories created using informatica?
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
How the dimensions will be loaded?
How to update records in Target, without using Update Strategy?
What is aggregate awareness?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
Hi experts, can anyone tell how much we use plsql in real time
In which circumstances that informatica server creates Reject files?