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
waht type of interface is used for testing the data in informatica
How do you load only null records into target? Explain through mapping flow.
How do you handle two sessions in Informatica
Explain incremental aggregation in informatica
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are multi-group transformations?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How many number of sessions can one group in batches?
What is a node in Informatica?
What are the different ways to implement parallel processing in informatica?
Explain joiner transformation in informatica
What is the difference between Active and Passive transformation?
What is the use of code page?
What are the components of Informatica? And what is the purpose of each?