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 / sri
It is useful in combining all the multiple columns in to a
single column and viceversa.
Let me know if this is wrong.....!
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can you use flat files in Mapplets.
What is the function of aggregator transformation?
How to improve the performance of a session using sorter transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is an aggregator transformation?
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 is flashback table ? Advance thanks
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How would you join a node to the already existing domain?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Sequence generator, when you move from develoment to production how will you reset
What is a pre-defined event and user-defined event?
Explain Dataware house architecture .how data flow from intial to end?
What is a difference between complete, stop and abort?