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

How an expression transformation differs from aggregator transformation?

628


What is the difference between stop and abort in informatica

666


What do you mean by channel change?

545


Explain the code page compatibility?

643


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

718






3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1760


What are the restrictions of union transformation?

581


What are the new features of informatica 9.x in developer level?

568


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

795


Explain the different kinds of facts.

566


What is native users?

725


How do we call shell scripts from informatica?

599


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1412


whats the logic to load the lower level of granularity of data to fact table.

1807


What is a filter transformation?

573