hi all,
can anyone please tell me the difference between erwin tool
and informatica ?how these both works ? how this both are
going to connect with business objects. THANKS IN ADVANCE
Answers were Sorted based on User's Feedback
Answer / indira meduri
Erwin is a Data Modeller tool. It is almost like MS Visio.
we can create a Logical or Physical database using this
tool. This tool shows a broad view of how tables are
connected to each other with their relationships too.
Well we can also create a brand new database schema or even
reverse engineer an existing schema too.
Informatica is an ETL tool.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / nag
Hi,
Hi Erwin is a Data Modeling tool and Informatica is a ETL
Tool. These two are different tools. But after doing data
modeling in Erwin , Informatica come into picture. Business
Objects comes after the ETL Developer part is completed.
Business Objects is a reporting tool. It takes the reports
from the datawarehouse.
This is as per my knowledge.
Is This Answer Correct ? | 4 Yes | 0 No |
Explain how many types of dimensions are available in informatica?
What are the challenges you have faced in your project?
What are the disadvantages of Sequence Generator T/R?
Suppose we do not group by on any ports of the aggregator what will be the output?
What does refresh system mean, and what are its distinctive choice?
How do you join more than 3 flat files in informatica?
why we use source qualifier transformation?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
write a query to retrieve the latest records from the table sorted by version(scd)
what are the output files that the informatica server creats during running a session?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in