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
How can you generate reports in informatica?
How to open an older version of an object in the workspace?
What is sq transformation?
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.
What is confirmed fact in dataware housing?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How can we use mapping variables in informatica?
difference between repository database and repository service?
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
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?
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
In how many ways we can create ports?
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 .
Separate from a database, an information bazaar, and an information stockroom?