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?
- 4 Answers
- 8515 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / rakesh ameta
select male,female from
(select row_number() over (order by (select 1)) as ID,names as male from gen where genders='male') a
FULL join
(select row_number() over (order by (select 1)) as ID,names as female from gen where genders='female') b
on a.id=b.id
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the differences between a connected lookup and unconnected lookup?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
how to create user defined function (udf) in informatica
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How many ways a relational source definition can be updated and what are they?
How many ways are there to do 'remove duplicate records in informatica'?
What are the reusable transformations?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
wf dont have integration severances how you can run?
What is a snowflake schema?
What is an active transformation?
What are the tasks that can be performed using sq?
