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
- 27657 Views
- FCS, IBM, Satyam, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / karthik
Normalizer transformation mainly used for changing the multiple record into a slngle row.
where as in this transformation rows converted into columns and columns to rows.
for more understanding.....
source table target table
eng mat | A B C D E F G
A 88 90 |
B 11 22 | ENG 88 11 44 77 88 88 96
C 44 85 | MAT 90 22 85 85 66 88 69
D 77 85 |
E 88 66
F 88 88
G 96 69
MOSTLY WE CANT USE THIS TRANSFORMATION IN THE PROJECTS
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sri
It is useful in combining all the multiple columns in to a
single column and viceversa.
Let me know if this is wrong.....!
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / murthy
I'm not expert , actually i'm a new commer on datastage
i think this problem can be achieved by using pivot stage
because it converts the multiple columns data format in to
the multiple rows format, so i think it will be useful for u
thanks
murthy
| Is This Answer Correct ? | 0 Yes | 1 No |
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 |
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
need for registering a repository server
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
Explain the pipeline partition with real time example?
Whats the difference between $, $$, $$$
What are active transformations? Name them.
Can we create multiple integration service on single repository?
What are the types of presistent cache in look up tr.
HOW DO YOU CONNECT TO REMOTE SERVER ?
I have source like this 1:2;3. so i want to load the target as 123
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
What is the functionality of update strategy?
Teradata 
