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
- 25529 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
can u any challenge your project?
Briefly describe lookup transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the advantage of informatica?
Explain Dataware house architecture .how data flow from intial to end?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the static cache and dynamic cache in informatica?
Reusable transformation and shortcut differences
what is song in infrmatica...?
State the differences between sql override and lookup override?
Why filter transformation is an active one?
Could you explain what is enterprise data warehouse?
tell me 5 session failure in real time how can you solve that in your project?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to create or import flat file definition in to the warehouse designer?
