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 |
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How to delete first 3 rows & last 3 rows in target table in informatica
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
difference between informatica 8.1.1 and 8.6
In which transformation you cannot drag ports into it?
How can we store previous session logs?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
How to read data from flat file source if the data is in paragraph format?
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
How to recover the standalone session?
How do you promote a non-reusable transformation to reusable transformation?