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
- 9846 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
How are the sources and targets definitions imported in informatica designer?
How to extract the informatica rejected data?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Differences between connected and unconnected lookup?
What is the difference between a repository server and a powerhouse?
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
What if the source is a flat-file?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the maplet?
What is the sql query overwrite in source qualifier in informatica
Define Pmrep command?
How do you migrate data from one environment to another?
Explain the pipeline partition with real time example?
Which is the t/r that builts only single cache memory?
How do you set a varible in incremental aggregation
