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 / karthik
Normalizer transformation mainly used for changing the multiple record into a slngle row.
where as in this transformation rows converted into columns and columns to rows.
for more understanding.....
source table target table
eng mat | A B C D E F G
A 88 90 |
B 11 22 | ENG 88 11 44 77 88 88 96
C 44 85 | MAT 90 22 85 85 66 88 69
D 77 85 |
E 88 66
F 88 88
G 96 69
MOSTLY WE CANT USE THIS TRANSFORMATION IN THE PROJECTS
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
In informatica workflow manager, how many repositories can be created?
What do you mean incremental aggregation?
Describe the impact of several join conditions and join order in a joiner transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How can we use mapping variables in informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Can you generate sequence numbers without using the sequence generator transformation?
Describe expression transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
how we can load rejected record's at run time?(not through bad files)
What are the performance considerations when working with aggregator transformation?
How to call shell scripts from informatica?
Explain the different dimensions.