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
- 8328 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
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How to improve the performance of a session using sorter transformation?
Can we create a Integration service without a Repository service and vice versa?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Mention few power centre client applications with their basic purpose?
In development project what is the process to follow for an etl developer from day1
What is the difference between informatics 7x and 8x and what is latest version?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How do you load only null records into target? Explain through mapping flow.
Can you generate sequence numbers without using the sequence generator transformation?
Explain lookup transformation source types in informatica
can any one give some examples for pre sql and post sql(Except dropping and creating index).
what is the difference between informatica6.1 and infomatica7.1
How to join three sources using joiner? Explain though mapping flow.
During the running session, output files are created by informatica server. Enlist few of them.
