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
- 27615 Views
- FCS, IBM, Satyam, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the measure objects?
What could be the possible resons of locks by user?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Repository user profiles
What do you understand by a term domain?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a filter transformation and why it is an active one?
what is SDLC way of code development?
What are the prerequisite tasks to achieve the session partition?
How many ways are there to create ports?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Differentiate between a repository server and a powerhouse?
Plz can any one say me how to get the informatica certification materials and dumps
How do you handle two sessions in Informatica
