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
- 27471 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 is exclusive and normal mode for repository services?
What all are steps in up gradation of Informatica server?
Explain sessions and how many types of sessions are there?
How do you load only null records into target?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the guidelines to be followed while using union transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Could you explain what is enterprise data warehouse?
Repository user profiles
Can we create multiple integration service on single repository?
What is event and what are the tasks related to it?
What is the advantage of informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
tell me about your project functionality
