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?
- 8 Answers
- 12627 Views
- BRAD, TCS, I also Faced
- E-Mail Answers
Answer Posted / moorthy g
Source-SQ-Exp-Rtr-Tgt(twice)
Exp:
Flag: DECODE(True, gender='MALE', 'Y','N')
RTR:
Make It Two Group
Flag value is Y then Male is one group.
Defaull is Female
Tgt:
Make It Two;
male - Tgt1
female - Tgt2
=================
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the types of schemas we have in data warehouse and what are the difference between them?
How do you load only null records into target?
Scheduling properties,whats the default (sequential)
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is joiner transformation?
When do you use sql override in a lookup transformation?
How to do the error handling of if ur source is flatfiles?
what is informatica metadata?
What is domain and gateway node?
What are the various types of transformation?
How to improve the performance of a session using sorter transformation?
Explain what is informatica metadata and where is it stored?
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 a transaction control transformation?
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?
