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
- 12512 Views
- BRAD, TCS, I also Faced
- E-Mail Answers
Answer Posted / star
Not sure if this has to be solved by SQL or by informatica -
and source is a table or file.
select * from (select lead(gender,0,0) over (partition by
gender), lead(gender,1,0) over (partition by gender) from
table1) where rownum=1
union all
select t1.name, t2.name from
(select name,row_number() over (partition by name) from
table1 where gender='male') t1,
(select name,row_number() over (partition by name) from
table1 where gender='female') t2
where
t1.name(+) = t2.name(+)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what is the size of u r source(like file or table)?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How to partition the Session?
What is the reusable transformation?
How can you validate all mappings in the repository simultaneously?
What is olap (on-line analytical processing?
where to store informatica rejected data? How to extract the informatica rejected data?
What is informatica etl tool?
Define sessions in informatica etl?
Describe data concatenation?
What is parallel processing in informatica?
can anyone suggest best free Talend data integration training online
In how many ways we can create ports?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is a predefined event?
