How can you define a transformation? What are different
types of transformations in Informatica?

Answer Posted / rahul

a transformation basically is a mechanism which enables
transforming the data as per the business requirement.
for eg in the source database if the date is in the mm dd
yyyy format and in the target database the date is in dd mm
yyyy format,so we apply transformation to remove the
inconsistancy

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain a relation schema and a relation?

582


What is aggregate fact table?

521


I know of using applysimple, but there are other ways too?

551


Explain the data type of the surrogate key?

558


What is vldb(very large databases)?

534






Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

510


Why should we use data ware housing and how can you extract data for analysis with example?

550


After the complete generation of a report who will test the report and who will analyze it?

542


Explain what are data marts?

579


What is a functional dependency f said to be minimal?

536


Explain hybrid slowly changing dimension?

555


What is meta data and system catalog?

1844


What should I have in mind when building olap solution from scratch?

521


Explain difference between snow flake and star schema.

543


Explain are data mart and dwh normalized or denormalized? Do both of them exist in

578