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
Differences between connected and unconnected lookup?
How do you migrate data from one environment to another?
What is the reusable transformation?
What is a joiner transformation and why it is an active one?
What is the status code in stored procedure transformation?
what is song in infrmatica...?
draw informatica architecture 8.6 ?
what is INFORMATICA TESTING process
How can we use mapping variables in informatica?
Briefly describe lookup transformation?
Define update strategy?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain sessions. Explain how batches are used to combine executions?
How can you increase the performance in joiner transformation?