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
- 9455 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 |
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
What is complex mapping?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
Can anyone tell me the new features in Informatica 9 Version?
What is confirmed dimension?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
What will be the approach?
1 lac of flat fles in source how to load target at a time?
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
star and snowflake schema?
How do you create single lookup transformation using multiple tables?
how to calculate the optimum cache size in aggregator transformation?
Teradata 
