1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / ramanaetl06

Answers were Sorted based on User's Feedback



i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno..

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

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno..

Answer / chandu

question is not clear

Is This Answer Correct ?    2 Yes 0 No

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno..

Answer / ravi

logic IS GREAT.
BUT, HOW INTEGRATION SERVICE INITIALIZES V_COUNT AS '0' , SO
THAT V_COUNT+1 RETURNS '1'?

Is This Answer Correct ?    0 Yes 0 No

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno..

Answer / rsbandaru

Ok..Integration service by default assigns value 'o' to the
variable port..

Is This Answer Correct ?    0 Yes 0 No

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno..

Answer / reddy

Hi, Sameer
r u checked that logic

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Define enterprise data warehousing?

0 Answers  

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

How to update records in Target, without using Update Strategy?

3 Answers  

how to convert the .doc docs into .txt format using informatica

4 Answers  

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  




When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

What are the two modes of datamovement in informatica sever?

2 Answers  

how many data models u have done in informatica project?

2 Answers   TCS,

wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,

what is the predefined port in dynamic lookup

2 Answers  

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  

Write the advantages of partitioning a session?

0 Answers  

For more Informatica Interview Questions Click Here
Categories