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
- 9836 Views
- Patni, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / gunjan singhal
select c1+c2+c3+c4 from table1
union all
select c1+c2+c3+c5 from table1
| Is This Answer Correct ? | 0 Yes | 7 No |
what is mean by flag 4 in update strategy t/r
what is a transforamation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
what is upstream and downstream transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
What are the new features of informatica 7.1?
what is the size of ur database(like oracle)
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Explian the Process of deployment groups in informatica
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
How the Informatica Server reads perameter file?
Teradata 
