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

In my sourse i have like
ename,gender
vasu,male
geetha,female
ram,male
suma.female
kesav,male

in my output i need
male,female
vasu,geetha
ram,suma
kesav

Question Posted / srinivas.medagum

Answers were Sorted based on User's Feedback



In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male..

Answer / srinivas.medagum

When i used SQ..>EXPRESSION T/R...>ROUTER...>UNION...>TRG

I AM GETTING OUTPUT ,BUT NOT IN PROPER LIKE
MALE,FEMALE
VASU
RAM
KESAV
SEETHA
SUMA


CAN I USE TWO TARGETS , HOW CAN GET IN PROPER WAY?

Is This Answer Correct ?    0 Yes 0 No

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male..

Answer / viney

it can be done using Normalizer transformation

Is This Answer Correct ?    0 Yes 0 No

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male..

Answer / sakthi

1.sq1 (query override gender='m') -> exp1 ,seq1 gen nextval to exp1

2.sq2 (query override gender='f') -> exp2 ,seq2 gen nextval to exp2

3. connnect o/p exp1 to exp2 to joiner
* condition nextvalue =nextvalue
* condition type full outer join

4. connect name from exp1 & name from exp2 to target

Is This Answer Correct ?    0 Yes 0 No

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male..

Answer / shiva bansal

use router and expr1 for male and expr2 for female
combine them in expression transformation and connect the
expression to target

Is This Answer Correct ?    0 Yes 1 No

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male..

Answer / suri

Write the condition based on the gender . so that all males
comes one side and females come another side

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

How union transformation is used?

0 Answers  

How to Create a folder using pmrep command?

0 Answers  

what is Active lock explain

0 Answers   Satyam,

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

When the informatica server marks that a batch is failed?

1 Answers  

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

wf dont have integration severances how you can run?

0 Answers   TCS,

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

For more Informatica Interview Questions Click Here
Categories