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
- 12832 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
where to store informatica rejected data?
What is the difference between stop and abort in informatica
Explain direct and indirect flat file loading (source file type) - informatica
Briefly define reusable transformation?
How would you join a node to the already existing domain?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Is stop and abort are same in informatica?
What are connected or unconnected transformations?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What could be the possible resons of locks by user?
What if the source is a flat-file?
Define enterprise data warehousing?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the difference between source qualifier transformations source filter to filter transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
