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

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

why u go for dimensions ?

3 Answers   TCS,

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

0 Answers  

Explain in detail about scd type 1 through mapping.

0 Answers  




My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

what is the method of error handling when session is running?

1 Answers   TCS,

What is a router transformation?

0 Answers  

Can you copy the session to a different folder or repository?

2 Answers  

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

What is dynamic cache?

0 Answers  

For more Informatica Interview Questions Click Here
Categories