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
- 25533 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
Is it possible to revert a global repository to local one and why?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is difference between a gateway node and worker node?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is lookup transformation?
How we can create indexes after completing the loan process?
What are the designer tools for creating transformations?
How can we use mapping variables in informatica?
How many number of sessions can one group in batches?
What is sequence generator transformation in informatica?
Can you generate sequence numbers without using the sequence generator transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is domain and gateway node?
