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 a joiner transformation and why it is an active one?
What r the type of indexes u generally used in informatica?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
what is target load plan
What is the sql query overwrite in source qualifier in informatica
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
how to load only the first and last record of a flat file into the target?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
How to implement security measures using repository manager?
What are the components of workflow manager?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?