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

Informatica and datawarehousing courses in Pune?

2 Answers  

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

Can we run session without using workflows?

5 Answers   TCS,

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,

what is mystery dimension?

1 Answers  

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  

what is the dashbords?

1 Answers   IBM,

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

For more Informatica Interview Questions Click Here
Categories