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?
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 do you load alternate records into different tables through mapping flow?
permutations of mapplet
What is informatica powercenter repository?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the differences between source qualifier and joiner transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Differences between version 7.x and 8.x.
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.
Explain lookup transformation source types in informatica
On which transformations you created partitions in your project?
Please let me know how to make encryption and decryption with example?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the need of an ETL tool?
Define mapping and session?
What is the sequence generator transformation in informatica?