Interested to Buy Any Domain ? << Click Here >> for more details...
Converting Rows to columns
I have Relational source like his.
JAN FEB MAR APR
100 200 300 400
500 600 700 800
900 100 200 300
I need to convert these rows into columns to the targe.
MONTH TOTAL
JAN 1500
FEB 900
MAR 1200
APR 1500
Please experts help me
- 5 Answers
- 11410 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / shankar
source qualifier > expression <for best practice> > aggregator > normalizer . target.
here in this the SQ will be for relational & flat files, then we use expression for best practice, in this we take the ports which we need into target also we can rename the ports for our convenience just to avoid confusion.
Then for calculating totals we use aggregator.
to convert the rows to col we use the normalizer. This is to my knowledge. Thank you if wrong pls post.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the need for an etl tool?
What is difference between a gateway node and worker node?
Why sorter is an active transformation?
What is an expression transformation?
Explain your project of banking domian.
can you please explain me pre session and post session options?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is mapplet in informatica?
Explain what are the different types of transformation available in informatica.
what is the -ve test case in your project.
can anyone explain me about retail domain project in informatica?
How can we use batches?
Is it possible to use a client with different version than that of its Informatica server?
