I believe c1 c2 c3 are the columns you can override the source qualifier

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?

Question Posted / krishnendu guha

2 Answers
9809 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

Please Help Members By Posting Answers For Below Questions

lookup transformation with screenshots

3988

What are the modules in Power Center

1669

Why update strategy and union transformations are active? Explain with examples.

1221

How to load last n records of file into target table - informatica

1055

How do you load first and last records into target table?

1145

Explain the features of connected and unconnected lookup.

922

What is standalone command task?

1307

What do you understand by SOA of Informatica?

967

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2015

What are the tasks that source qualifier perform?

1089

What are junk dimensions?

1058

How do you load unique records into one target table and duplicate records into a different target table?

1208

Can we override a native sql query within informatica?

1025

How to generate sequence numbers using expression transformation?

1078

Explain why we use partitioning the session in informatica?

1075