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
Answer Posted / 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 |
Post New Answer View All Answers
What is a passive transformation?
Quickly characterize reusable change?
What are the prerequisite tasks to achieve the session partition?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Parameter and variable differences
How to do unit testing in informatica?
Target increases every day even though no new record was inserted
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the components of Informatica? And what is the purpose of each?
Why do you use Mapping Parameter and mapping variable?
Define mapplet?
Briefly describe lookup transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures