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
- 26460 Views
- FCS, IBM, Satyam, TCS, I also Faced
- E-Mail Answers
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
What is mapping debugger?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to extract sap data using informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
difference between repository database and repository service?
Explain the scenario which compels informatica server to reject files?
What is repository manager?
What are the data movement modes in informatica?
Differentiate between source qualifier and filter transformation?
Which are the different editions of informatica powercenter that are available?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is domain and gateway node?
In informatica workflow manager, how many repositories can be created?
Can we get 1st record through Informatica(without sequence number).
