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
- 27636 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
Enlist the various types of transformations.
What is dynamic cache?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is intricate mapping?
How to load data in informatica ?
How can we remove the duplicates from flat file source?
Explain pushdown optimization $pushdownconfig parameter - informatica
On which transformations you created partitions in your project?
Mention few advantages of router transformation over filter transformation.
Can we change Dynamic to Static or Persistent cache? If so what happens?
Which transformation is needed while using the Cobol sources as source definitions?
How to extract sap data using informatica?
What is meant by query override?
what is SDLC way of code development?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
