why we need informatica

Answer Posted / mike

well informatica is the tool used for data aquisition
process..which is nothing but data extraction, data
transformation and data loading. Inorder to build a data
ware house we use informatica
or
It is a GUI tool and we need informatica for
running,designing,monitoring and administrating the data
flow from various external source and internal sources to
the data ware house

correct me if i was wrong

Is This Answer Correct ?    19 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how many types of dimensions are available in informatica?

599


What is the advantage of informatica?

650


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

720


What are the main features of Oracle 8i with context to datawarehouse?

1684


Enterprise data warehouse your projects phase by phase explain?

1474






Explain constraint based loading in informatica

663


What are mapplets? How is it different from a Reusable Transformation?

630


what is degenerated dimension?

3160


What differs when we choose the sorted input for aggregator transformation?

576


differences between service based and product based?

1569


how many types of dimensions are available in informatica?

565


Explain about cumulative Sum or moving sum?

625


Explain the tuning lookup transformation - informatica

615


How to open an older version of an object in the workspace?

620


How can you generate reports in informatica?

585