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.
Answer Posted / 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 |
Post New Answer View All Answers
How can we use mapping variables in informatica?
Under which circumstances, informatica server creates reject files?
Different qualification between a related rotate toward the sky and isolates look upward?
What is the function of look up transformation?
How can you validate all mappings in the repository simultaneously?
What do think which one is the better joiner or look up?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is a sorter transformation?
What is the Rank index port in Rank transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
Explain in detail scd type 2 through mapping.
What are the advantages of informatica?
Why union transformation is an active transformation?
What is aggregator transformation in informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?