regarding pivot stage

[Saama]

hi,
as pivot stage transforms vertical rows into horizontal and vise versa.
i went through manual and found that these rows should have relationship.
i want to help my team lead to exactly analyze the working of pivot stage.
my source data has colums like
CUSTOMER ID PAYEMENT LOCATION. i see that these columns are independent, what happens when i use pivot stage as the i/p.
i will appreciate if somebody helps me in analyzing the pivot stage, and what happens when i use pivot stage.

cheers;
saama

[ray.wurlod]

Firstly, your "and vice versa" is incorrect. The Pivot stage only performs horizontal pivoting (columns to rows). It does not perform vertical pivots.

The manual (pivot.pdf) gives a number of examples, and explains precisely how horizontal pivots work. I see no need to recapitulate that material here.

The only example it lacks, which I feel should be there, is one where a pivot key column is a constant (such as period names) added in an upstream Transformer stage.

[kumar_s]

Hi Saama,

Pivot stage by itself doesn't care about relationships between fields. As an ETL user you should take care of the given business rules to accomplish the task.
If you have multiple PAYEMENT LOCATION fields as PAYEMENT LOCATION1, PAYEMENT LOCATION2...for a same customer (CUSTOMER ID), the pivot of PAYEMENT LOCATION's against CUSTOMER ID will give you meaning full transformation. If you need to Pivot CUSTOMER ID and PAYEMENT LOCATION against another key column, you get a meaningless output unless PAYEMENT LOCATION at some condition refer to CUSTOMER ID or vise versa.

[Saama]

Hi gurus,
Thanks very much.

cheers;
saama