Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9951 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 persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Enlist the differences between database and data warehouse.
Parameter and variable differences
how we can load rejected record's at run time?(not through bad files)
What are data-driven sessions?
Enlist the tasks for which source qualifier transformation is used.
How might one distinguish in the case of mapping is right or not without associating session?
what is song in infrmatica...?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the use of code page?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the different types of repositories created using informatica?
What are the databases that informatica can connect to windows?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
