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
- 9687 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 Target definition for flat files?
What is data transformation manager process?
What is status code in informatica?
Briefly describe lookup transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain about Informatica server process that how it works relates to mapping variables?
How to do the error handling of if ur source is flatfiles?
How does the aggregator transformation handle null values?
What is session task and command task?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
r u done any partitions in ur project?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the benefit of partitioning a session?
Plz can any one say me how to get the informatica certification materials and dumps
How to use pmcmd utility command?
