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
- 9499 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
How do you recover rows from a failed session
What is xml source qualifier transformation in informatica?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
what is the size of u r project? and what is the size of source file?
How do you load only null records into target?
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
what is the process of target load planing?
how to delete duplicate records by using filter transfermation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
what is the size of ur database(like oracle)
how to get the only updated records in the target
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
Teradata 
