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
- 27781 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
What does “tail –f” command do and what is its use as an Informatica admin.
How to do unit testing in informatica?
what is the hint? how to use it to reduce the query processing in program?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How you prepared reports for OLAP?
What is aggregator transformation in informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to join three sources using joiner?
In how many ways we can create ports?
explain one complex mapping with logic? sales project?
During the running session, output files are created by informatica server. Enlist few of them.
Mention a few design and development best practices for informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
What is the commit type if you have a transaction control transformation in the mapping?
Why is sorter an active transformation?
