by using normalizer transformation we can convert rows to columns. s-

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

Question Posted / usha

5 Answers
11198 Views
HP, I also Faced
E-Mail Answers

Answer Posted / usha

by using normalizer transformation we can convert rows to
columns.

s-->SQ--->NRM-->Target

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is SDLC way of code development?

1967

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2251

How to implement security measures using repository manager?

1082

is it possible to index the data in cache of lkp transformation ?

1958

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1851

What is a surrogate key?

1016

What is the difference between informatics 7x and 8x and what is latest version?

1022

What are active transformations.

1591

Scheduling properties,whats the default (sequential)

1890

Explain the aggregator transformation?

1092

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

982

What is aggregate cache in aggregator transformation?

1061

Explain load alternative records / rows into multiple targets - informatica

1099

How can we use batches?

961

Different sorts of metadata that stores in the storage facility?

947