Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 27390 Views
- FCS, IBM, Satyam, TCS, I also Faced
- E-Mail Answers
Answer Posted / kishore
Hi,
according to my idea, take 3 different groups in the
normalizer transformation like....
1. stud_id studname
------- --------
1 Ramesh
2 Himesh
3 Mahesh
2. Sub_id Subname
------- -------
10 ENG
20 MAT
30 ART
3. sub_id stud_id marks
------ ------- -----
1 10 68
1 20 82
1 30 78
2 10 73
2 20 87
2 30 89
3 10 81
3 20 79
3 30 64
make sure that all these 3 groups have proper relationship
with each other.
finally map the appropriate fields to the target.
I'm not exactly sure about this answer but i would be
thankfull for any suggestions.
have a nice day. Kishore.
| Is This Answer Correct ? | 9 Yes | 12 No |
Post New Answer View All Answers
What is the difference between Active and Passive transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is informatica powercenter repository?
What are mapplets? How is it different from a Reusable Transformation?
What is parallel processing in informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How would you join a node to the already existing domain?
How to elaborate tracing level?
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 you can differentiate between connected lookup and unconnected lookup?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What do you mean by channel change?
What is a snowflake schema?
How do you load only null records into target?
how many types of dimensions are available in informatica?
