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 tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

Can we update the data in flat file using update strategy?

3 Answers  

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

What is informatica metadata and where is it stored?

0 Answers  

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,




star and snowflake schema?

6 Answers  

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  

For more Informatica Interview Questions Click Here
Categories