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
- 9657 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 will compare two mappings in two different repository?
How to delete first 3 rows & last 3 rows in target table in informatica
what is the flat file partition and where have to specify it
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
what are factless facts? And in which scenario will you use such kinds of fact tables.
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
What is staging area?
Tell me one complex query in oracle ?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
Teradata 
