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
- 8360 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
How to do unit testing in informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is a node in Informatica?
What does “tail –f” command do and what is its use as an Informatica admin.
How to load last n records of file into target table - informatica
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the meaning of decode in informatica?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is Session and Batches?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is a snowflake schema?
What is union transformation in informatica?
