use Normalized transformation in the mapping.we get result.

write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000

Question Posted / lchenchureddy

Answer Posted / lchenchureddy

Is This Answer Correct ?

2 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Define joiner transformation?

982

How you know when to use a static cache and dynamic cache in lookup transformation?

1791

How many dimensions are there in informatica?

1022

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1023

What is meant by incremental aggregation?

1020

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2056

How to update or delete the rows in a target, which do not have key fields?

1115

Explain about Informatica server process that how it works relates to mapping variables?

1004

How do you load only null records into target?

1138

Scheduling properties,whats the default (sequential)

1888

What is the difference between source qualifier transformations source filter to filter transformation?

994

What is transformation?

1049

What is informatica powercenter repository?

1139

expain about the tune parameters?

2336

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1627