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?
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
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Did u used latest transformations of 8.6.0? for what?
How to load data in informatica ?
How can you increase the performance in joiner transformation?
what is the hint? how to use it to reduce the query processing in program?
what is Active lock explain
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is a passive transformation?
What is a predefined event?
Is it possible to revert a global repository to local one and why?
Difference between Target-based loading and constraint-based loading?
What do you mean by worklet?
How does a rank transform differ from aggregator transform functions max and min?
Explain transaction control transformation in informatica