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
What is decode in informatica?
What is the Process to creating lookup transformation in informatica
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How to partition the Session?
explan ur project architecture?
What is a repository manager?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Can we create two repositories on same database instance in oracle?
In informatica workflow manager, how many repositories can be created?
What is a snowflake schema?
What are the reusable transformations?
What is transformation?
What is fact table? Explain the different kinds of facts.
What are the differences between joiner transformation and source qualifier transformation?
How will the document be delivered to me?