we have tables like
c1 a
c2 b
c3 c
c4 x
c5 y
and i need output like abcx in a single row and abcy in
a single row? how do u do this?
- 2 Answers
- 9192 Views
- Patni, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / krishnendu guha
I believe c1 c2 c3 are the columns
you can override the source qualifier with the following
query
select c1,c2,c3,c4 from table1
union all
select c1,c2,c3,c5 from table1
this should do..
| Is This Answer Correct ? | 10 Yes | 9 No |
Post New Answer View All Answers
Where do we use mapping variables in informatica?
How can we handle two sessions in informatica?
What is informatica powercenter repository?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How do you handle two sessions in Informatica
How to update or delete the rows in a target, which do not have key fields?
Differentiate between Load Manager and DTM?
difference between informatica 8.1.1 and 8.6
What is the need of an ETL tool?
What is a sorter transformation?
What is confirmed fact in dataware housing?
What is sequence generator transformation in informatica?
lookup transformation with screenshots
What is Data Caches size?
How to Create a folder using pmrep command?
