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

Answer Posted / hemanth

use joiner.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between informatica 7.0 and 8.0?

649


how to load rows into fact table in data warehouse

746


How we can create indexes after completing the loan process?

838


What is the need of etl tools?

715


Explain the different dimensions.

650






Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1315


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1736


What is the difference between source qualifier transformations source filter to filter transformation?

709


what is size of u r database?

1942


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7801


What is the function of aggregator transformation?

667


What is meant by active and passive transformation?

679


What is the function of union transformation?

713


When do you use sql override in a lookup transformation?

670


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

728