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
- 27389 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 powercenter on grid?
Global and Local shortcuts. Advantages.
Explain load alternative records / rows into multiple targets - informatica
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is meant by LDAP users?
How you prepared reports for OLAP?
Briefly describe lookup transformation?
What is substr in informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is data transformation manager process?
How does the aggregator transformation handle null values?
What is joiner transformation in informatica?
what is the -ve test case in your project.
What is flashback table ? Advance thanks
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
