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
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Explain pushdown optimization and types in informatica
How does the aggregator transformation handle null values?
What are the features of complex mapping?
Enlist some properties of sessions.
What is meant by lookup transformation? Explain the types of lookup transformation?
How to create the source and target database connections in server manager?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the types of data warehouses?
Where are the source flat files kept before running the session?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What do mean by local and global repository?
Explain the use of aggregator cache file?
Is there any target staging area in informatica not staging area
permutations of mapplet