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

Different circumstance which drives informatica server to expel records?

0 Answers  

How to fix the etl bugs..Tell me the process?

1 Answers   IBM,

Global and Local shortcuts. Advantages.

0 Answers  

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

can we create index and drop index in exsisting table while using infomatica

4 Answers  

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

What you know about transaction control transformation?

0 Answers  

what is runtime variable?

3 Answers   TCS,

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories