In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?

Answer Posted / rajkumar_bachu

By using Normalizer transformation we can normalize the data.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

889


lookup transformation with screenshots

3555


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

710


While importing the relational source definition from the database, what are the metadata of source that will be imported?

784


what are the Methods For Creating Reusable Transformations?

647






Could you explain what is enterprise data warehouse?

551


What is enterprise data warehousing?

611


difference between repository database and repository service?

616


What is union transformation in informatica?

695


if we have a delimiters at unwanted places in a flat file how can we over come those.

1564


How to generate sequence numbers?

616


Why filter transformation is an active one?

561


Explain lookup transformation in informatica

642


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?

783


What is the advantage of informatica?

642