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
- 9845 Views
- Patni, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the command used to run a batch?
What is a transaction control transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is InformaticaPowerCenter?
4 yrs etl devloper roles and responsibilities?any body give solutions
difference between informatica 8.1.1 and 8.6
What is the different lookup cache(s)?
What are the modules in Power Center
While migrating the data from one environment to another environment how would you manage the connections?
What is a sorter transformation?
How to do the error handling of if ur source is flatfiles?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is powercenter on grid?
