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
- 9180 Views
- Patni, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Do you find any difficulty while working with flat files as source and target?
what are the differences between powercenter 8.1 and powercenter 8.5?
what is the diff b/w union and joiner and lookup?
If I am having 6 flat files in data. How can you load the data at a time
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
What is best approach to load 100 different source files (Different structure) to differet target tables ?
what is Partitioning ? where we can use Partition?
When to use normalization transformation other than cobol source?
How to generate the HTML output using Informatica.
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
Explain the difference between a data warehouse and a data mart?
Teradata 
