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
- 27776 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
How to delete duplicate row using informatica?
What is meant by active and passive transformation?
What is substr in informatica?
Can we create multiple integration service on single repository?
which one is better performance wise joiner or look up
Explian the Process of deployment groups in informatica
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Parameter and variable differences
What are the various types of transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the types of schemas we have in data warehouse.
Sequence generator, when you move from develoment to production how will you reset
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is Session and Batches?
Target increases every day even though no new record was inserted
