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
- 9838 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 are the different lookup cache(s)?
Where is metadata stored?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are active and passive transformations?
Suppose we do not group by on any ports of the aggregator what will be the output?
what is index?how it can work in informatica
Write the advantages of partitioning a session?
What is a transaction control transformation?
Plz can any one say me how to get the informatica certification materials and dumps
What is the sequence generator transformation in informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is parallel processing in informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
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
What is the way to execute pl/sql script using informatica mapping?
