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
- 9373 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 |
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
What you know about transaction control transformation?
How to convert multiple rows to single row (multiple columns) in informatica
which is better perfomancewise lookup or joiner and why?can anyone give example?
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
Explain about HLD and LLD ?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
Explain dynamic target flat file name generation in informatica
how to get max value record into one target and remaining records into another target?
how to connect two or more table with single source qualifier?
What is the functionality of update strategy?
What is the difference between a repository server and a powerhouse?
Teradata 
