Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 9364 Views
- I also Faced
- E-Mail Answers
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 |
How can you increase the performance in joiner transformation?
tell me the rules and responsblites in our project(my project is development)
What is a test load?
What are the mapping paramaters and mapping variables?
What are the different types of repositories created using informatica?
what is casual dimension?
What are the ETL tools available in DWH?
wat are deployement groups in informatica, how it will be used for developers
What is power play plug in?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
without dynamic lookup how to insert new rows and update existing rows?
Teradata 
