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
- 9696 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
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How does a rank transform differ from aggregator transform functions max and min?
In informatics server which files are created during the session rums?
What are the limitations of joiner transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
During the running session, output files are created by informatica server. Enlist few of them.
How to create or import flat file definition in to the warehouse designer?
Which transformation should we use to normalise the COBOL and relational sources?
Mention few power centre client applications with their basic purpose?
Where is metadata stored?
What is informatica powercenter repository?
How to join three sources using joiner? Explain though mapping flow.
Explain incremental aggregation in informatica
What is lookup change?
