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
- 27391 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 is the difference between Active and Passive transformation?
what is bridge tables in informatica
what is fact and what types of fact tables is there
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Define Pmrep command?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
what is left outer join?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
What is persistent lookup cache?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Teradata 
