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
- 9959 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's the layout of parameter file (what does a parameter file contain?)?
How do you change a non-reusable transformation to reusable transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
what are factless facts? And in which scenario will you use such kinds of fact tables.
What does command task mean?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Do you find any difficulty while working with flat files as source and target?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Slowly changing dimensions, types and where will you use them
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Under what condition selecting sorted input in aggregator may fail the session?
design of staging area?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
