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
- 8988 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
What is the use of source qualifier?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are the measure objects?
What is transformation?
Is it possible to create multiple domains on a single Informatica server?
What are mapplets?
Can we create a Integration service without a Repository service and vice versa?
How to update a particular record in target with out running whole workflow?
How to open an older version of an object in the workspace?
have u done any performance tuning? how u ll do?
What are the uses of etl tools?
Is there any target staging area in informatica not staging area
What is the surrogate key?
What are the new features of informatica 9.x developer?
What are the components of workflow manager?
