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
- 9806 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
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are the different components of powercenter?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is a snowflake schema?
Explain the types of transformations?
What is meant by lookup transformation?
What is joiner transformation in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the guidelines to be followed while using union transformation?
What is the need for an etl tool?
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
How might you approve all mappings in the archive all the while?
What all are steps in up gradation of Informatica server?
how many types of dimensions are available in informatica?
