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
- 8738 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
tell me 5 session failure in real time how can you solve that in your project?
Explain what is informatica metadata and where is it stored?
Enlist few areas or real-time situations where informatica is required.
What is union transformation?
Partition, what happens if the specified key range is shorter and longer
What is an Integration service in Informatica?
Does an informatica transformation support only aggregate expressions?
How to open an older version of an object in the workspace?
What is data transformation manager process?
How to generate sequence numbers using expression transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
can you please explain me pre session and post session options?
What is the difference between a repository server and a powerhouse?
what is the -ve test case in your project.
