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


Please Help Members By Posting Answers For Below Questions

How can you generate reports in informatica?

565


How to open an older version of an object in the workspace?

604


What is sq transformation?

652


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1745


What is confirmed fact in dataware housing?

5649






what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1765


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

587


How can we use mapping variables in informatica?

586


difference between repository database and repository service?

608


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1616


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

776


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1738


In how many ways we can create ports?

692


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1461


Separate from a database, an information bazaar, and an information stockroom?

596