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
- 27400 Views
- FCS, IBM, Satyam, TCS, I also Faced
- E-Mail Answers
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 a transformation be made reusable?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the need of etl tools?
What are mapplets? How is it different from a Reusable Transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is meant by incremental aggregation?
Explain what transformation and how many are there in informatica?
Is it possible to create multiple domains on a single Informatica server?
Target increases every day even though no new record was inserted
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the differences between source qualifier and joiner transformation?
How you can differentiate between connected lookup and unconnected lookup?
What is data transformation manager process?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Clarify the aggregator change?
