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 / 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 an aggregator transformation?
How to partition the Session?
Describe an informatica powercenter?
can you please explain me pre session and post session options?
What is the need for an etl tool?
Explain lookup transformation source types in informatica
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain why we use partitioning the session in informatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
explain about unit testing? in real time?
How to do unit testing in informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the advantage of informatica?
r u done any partitions in ur project?
What is parallel processing in informatica?