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?
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 |
what is curr val use for in sequence generator?
What are the transformations that are not supported in mapplet?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
what type of transformation is not supported by mapplets?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
what is confirmed dimension?
How to implement security measures using repository manager?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
what is the hint? how to use it to reduce the query processing in program?
What are the different threads in DTM process?