i have one doubt.how to convert source to columns using sourcequalifier. ho

write sql query following source table

jan feb mar apr
100 200 300 400
500 600 700 800
900 100 200 300
i want the output format like

month total
jan 1500
feb 900
mar 1200
apr 1500

Question Posted / triveni

3 Answers
8666 Views
Accenture, I also Faced
E-Mail Answers

Answer Posted / triveni

i have one doubt.how to convert source to columns using sourcequalifier. how many columns target we have take.
how to connect source to target
source has 4 columns
target has 2 columns

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can you increase the performance in joiner transformation?

1248

What is depict expression change?

1194

Make a note of the quantity vaults made in informatica?

1044

Explain direct and indirect flat file loading (source file type) - informatica

1359

What is the session task and command task?

1115

What is the format of informatica objects in a repository?

1073

Briefly define reusable transformation?

1182

What is a transaction control transformation?

1261

What is data transformation manager process?

1221

What are the popular informatica products?

1056

What are the types of presistent cache in look up tr.

2104

Explain sessions?

1140

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2199

What are the conditions needed to improve the performance of informatica aggregator transformation?

1139

What is rank transform?

1061