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
- 25534 Views
- FCS, IBM, Satyam, TCS, I also Faced
- E-Mail Answers
Answer Posted / ramesh
Hi,
actually normalizer tr act as a datapivoting.
datapivoting sense to generate the multiple records from a single record.
| Is This Answer Correct ? | 26 Yes | 2 No |
Post New Answer View All Answers
How can we update a record in the target table without using update strategy?
Under what condition selecting sorted input in aggregator may fail the session?
scenario where i can use only concurrent execution of workflow.
What is the benefit of partitioning a session?
how to load dimension table and fact table. plz tell me the steps.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is meant by lookup transformation?
What is pmcmd command?
What is the meaning of up gradation of repository?
COM components can be used in Informatica
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Write the unconnected lookup syntax and how to return more than one column.
Describe the impact of several join conditions and join order in a joiner transformation?
Explain what are the different versions of informatica?
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
