Interested to Buy Any Domain ? << Click Here >> for more details...
following source
name gender
ramya female
ram male
deesha female
david male
kumar male
i want the target
male female
ram ramya
david deesha
kumar
any body give solution above question?
- 4 Answers
- 8262 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / zer0
Create the mapping as below:
EXP1 ---> SRT1
/ \
Src --> Router Joiner ---> EXP3 ---> Targ
\ /
EXP2 ---> SRT2
Router: Filter on the basis of gender. All records with
gender male wil go into EXP1 and the records with gender
female will go into EXP2.
In EXP1 and EXP2, create a variable dummy port (Seq_Var)
with value Seq_Var+1 and an output port Seq_Out (value-
Seq_Var).
Pass the name and sequence ports from EXP1 and EXP2 to SRT1
and SRT2 (sorter) respectively.
In SRT1 and SRT2, sort on the basis of sequence.
In Joiner, use 'Full Outer Join' and keep 'Sorted Input'
checked in properties.
Pass the male name values and female name values from
joiner to EXP3 (Gather all the data). Pass all the data to
Target.
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
What is source qualifier transformation in informatica?
What is meant by a domain?
How to generate sequence numbers without using the sequence generator transformation?
Which transformation is needed while using the Cobol sources as source definitions?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Design time, run time. If you don't create parameter what will happen
What are batches?
What are the types of caches in lookup?
How big was your fact table
What are the data movement modes in informatica?
Name the different lookup cache(s)?
What can we do to improve the performance of informatica aggregator transformation?
How to generate sequence numbers using expression transformation?
COM components can be used in Informatica
What is informatica? Why do we need it?
