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
- 27607 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 are the components of the workflow manager?
Enlist the various types of transformations.
How to create or import flat file definition in to the warehouse designer?
What are Dimensional table?
Explain sessions?
How will the document be delivered to me?
While migrating the data from one environment to another environment how would you manage the connections?
What is InformaticaPowerCenter?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What do you understand by SOA of Informatica?
Define pmcmd command?
What do think which one is the better joiner or look up?
whats the logic to load the lower level of granularity of data to fact table.
Can we create multiple integration service on single repository?
What is informatica metadata and where is it stored?
