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
- 9856 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 if the source is a flat-file?
How to open an older version of an object in the workspace?
What do you mean incremental aggregation?
How many number of sessions that u can create in a batch?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
explain different levels in pushdown optimization with example?
what are the real time problems generally come up while doing or running mapping or any transformation?
Can any one explain or sujjest some sites for scd mappings.Thank you
what are presession,postsession success and postsession failure commands ?
What is workflow? What are the components of the workflow manager?
In which circumstances that informatica server creates Reject files?
Teradata 
