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
What are the restrictions of union transformation?
have u done any performance tuning? how u ll do?
What is blocking transformation?
What is the need for an etl tool?
Enlist the advantages of informatica.
What are the different ways to implement parallel processing in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What does “tail –f” command do and what is its use as an Informatica admin.
What is the function of look up transformation?
Explain why we use partitioning the session in informatica?
What is a standalone command task?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what are the deliverables?in your project?
Define joiner transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?