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 / ghouse

cus_id ph
1002 9290123526
1002 9767192210
1002 9876545232

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explan ur project architecture?

1599


Explain the types of transformations?

598


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

656


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2299


How to create Target definition for flat files?

756






What do you mean by worklet?

633


Explain sessions?

606


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1679


How to join three sources using joiner?

575


What are junk dimensions?

636


is it possible to index the data in cache of lkp transformation ?

1528


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5832


What is joiner transformation in informatica?

629


my source is junk data how will u remove that junk data by using unix please any one replay me

3246


what is the -ve test case in your project.

1855