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

can you use flat file for lookup table?why?

2 Answers   HCL,

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

What is partioning?how many types of partinings are there

2 Answers   HCL,

In warehouses how many schemas are there?

0 Answers  

What is up date strategy and what are the options for update strategy?

2 Answers  

why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

Describe data concatenation?

0 Answers  

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

For more Informatica Interview Questions Click Here
Categories