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 / voma
use router transformation, In that 2 groups
1 is male, 2 is female,
target is single, but we drag the table twice
In that router 1st group condition
select * from table where gender='male'
2nd group condition
select * from table where gender='female'
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the commit type if you have a transaction control transformation in the mapping?
What is the meaning of up gradation of repository?
What are 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?
what is $$$$?
What do you understand by SOA of Informatica?
What do you mean incremental aggregation?
How do we call shell scripts from informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
explan ur project architecture?
Explain the mapping variable usage example in informatica