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

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

What are the different types of repositories created using informatica?

0 Answers  

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,




How the dimensions will be loaded?

0 Answers   HCL,

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

3 Answers  

What is aggregate awareness?

1 Answers  

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  

In which circumstances that informatica server creates Reject files?

2 Answers  

For more Informatica Interview Questions Click Here
Categories