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
- 9839 Views
- Patni, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / krishnendu guha
I believe c1 c2 c3 are the columns
you can override the source qualifier with the following
query
select c1,c2,c3,c4 from table1
union all
select c1,c2,c3,c5 from table1
this should do..
| Is This Answer Correct ? | 10 Yes | 9 No |
Post New Answer View All Answers
How does a rank transform differ from aggregator transform functions max and min?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
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
Separate from a database, an information bazaar, and an information stockroom?
waht type of interface is used for testing the data in informatica
What are active and passive transformations?
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?
How many input parameters can exist in an unconnected lookup?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
can u any challenge your project?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is informatica?
Describe an informatica powercenter?
What is data movement mode in Informatica and difference between them?
What is a stored procedure transformation?
