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
- 9742 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 |
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Quickly characterize reusable change?
What are the associated ports in look up T/R.
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
Explain dynamic target flat file name generation in informatica
how to get the first row without using rank t/r?
Differentiate between Load Manager and DTM?
how to sort date field in infomatica?
hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE
Write the prerequisite tasks to achieve the session partition?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
Teradata 
