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
explain one complex mapping with logic? sales project?
How can we use mapping variables in informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Mention few advantages of router transformation over filter transformation.
Informatica Checkpoints
How do you update the records with or without using update strategy?
What is session task and command task?
Explain the difference between a data warehouse and a data mart?
can u give example for factless fact table
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are some examples of informatica etl programs?
How we can use union transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain where to store informatica rejected data? How to extract the informatica rejected data?