1)can anyone explain how to use Normalizer transformation
for the following scenario

Source table | Target Table
|
Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh
Ramesh 68 82 78 | ENG 68 73 81
Himesh 73 87 89 | MAT 82 87 79
Mahesh 81 79 64 | ART 78 89 64
|
please explain what should be
the normalizer column(s)
The GCID column

2)Also please explain the Ni-or-1 rule.

Answer Posted / ramesh

Hi,
actually normalizer tr act as a datapivoting.
datapivoting sense to generate the multiple records from a single record.

Is This Answer Correct ?    26 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we can create indexes after completing the loan process?

742


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1539


What is workflow manager?

588


In informatics server which files are created during the session rums?

645


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1744






whats the logic to load the lower level of granularity of data to fact table.

1814


What are the types of schemas we have in data warehouse and what are the difference between them?

536


What is Session and Batches?

672


without table how to come first record only in oracle?

1866


How you prepared reports for OLAP?

1165


What are the guidelines to be followed while using union transformation?

648


Why sorter is an active transformation?

758


What are the various types of transformation?

656


What is the reusable transformation?

645


Explain the aggregator transformation?

642