i have one table like
cust_id ph1 ph2 ph3
1002 9290123526 97671927210 9876545232
we use Normalizer wt is o/p?
sue normalizer we can generate three tables in single table/
Answer Posted / subash
Hi Ghouse,
Can u pls explain how we achieve this, the logic in
normalizer, is it by just connecting the output ports from
normalizer to target , where we define ph1 occcuring 3 times
in normalizer transformation. Do we have to use any
expression transformation between the normalizer and the
target. Can some one who tried please explain the logic that
happens in normalizer transformation in splitting a single
row into multiple tuples
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can informatica be used for an organization?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the tasks that source qualifier perform?
Write the prerequisite tasks to achieve the session partition?
Describe an informatica powercenter?
How to update a particular record in target with out running whole workflow?
What is a code page?
What is a repository manager?
Can anyone tell me the new features in Informatica 9 Version?
Design a mapping to load the cumulative sum of salaries of employees into target table?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is workflow? What are the components of the workflow manager?
What is native users?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com