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 might you approve all mappings in the archive all the while?
What is the command used to run a batch?
What are the tuning techniques you applied during your last project
draw informatica architecture 8.6 ?
How many dimensions are there in informatica?
How do you change a non-reusable transformation to reusable transformation?
While migrating the data from one environment to another environment how would you manage the connections?
What is the difference between Active and Passive transformation?
What is complex mapping?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the main features of Oracle 8i with context to datawarehouse?
What all are steps in up gradation of Informatica server?
What is enterprise data warehousing?
Suppose we do not group by on any ports of the aggregator what will be the output?
In informatica workflow manager, how many repositories can be created?