Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 challenge face in u r project?explain me

1 Answers   iGate, TCS,

What is joiner transformation?

0 Answers  

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

Explain the code page compatibility?

0 Answers  

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  

What is parallel processing in informatica?

0 Answers  

What is data transformation manager process?

0 Answers  

How can you increase the performance in joiner transformation?

0 Answers  

What are the measure objects?

0 Answers  

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

For more Informatica Interview Questions Click Here
Categories