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

What are the designer tools for creating transformations?

774


can we override a native sql query within informatica? Where do we do it? How do we do it?

708


what is unit testing?tell me proceedure

1880


Briefly define reusable transformation?

724


How to delete duplicate row using informatica?

697






Design a mapping to load the cumulative sum of salaries of employees into target table?

1026


Explain the difference between mapping parameter and mapping variable?

707


How might you approve all mappings in the archive all the while?

707


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5450


Explain the etl program with few examples.

638


What are the steps involved in the migration from older version to newer version of Informatica Server?

1687


What is meant by lookup transformation? Explain the types of lookup transformation?

652


What can we do to improve the performance of informatica aggregator transformation?

715


What is fact table? Explain the different kinds of facts.

692


How can you increase the performance in joiner transformation?

807