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
- 9498 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 |
performance wise which one is better in joiner and lookup transformation
what are the real time problems generally come up while doing or running mapping or any transformation?
What are the scheduling options to run a sesion?
what is bridge tables in informatica
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
What is Java Transformation? what are the uses of it?
why union is active transformation?
What is the difference between a connected look up and unconnected lookup?
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 is upstream and downstream transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
Teradata 
