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 / sri
It is useful in combining all the multiple columns in to a
single column and viceversa.
Let me know if this is wrong.....!
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Mention few power centre client applications with their basic purpose?
What are the different transaction levels available in transaction control transformation?
In how many ways we can create ports?
Reusable transformation and shortcut differences
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Describe the impact of several join conditions and join order in a joiner transformation?
What are the new features of Power Center 5.0?
What is event and what are the tasks related to it?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How can informatica be used for an organization?
pmscmd startworkflow -sv
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is workflow monitor?
Partition, what happens if the specified key range is shorter and longer
What is a router transformation?