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 / 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 |
Post New Answer View All Answers
What is sq transformation?
Separate from an archive server and a powerhouse?
What is lookup change?
How do you load unique records into one target table and duplicate records into a different target table?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Design a mapping to load the cumulative sum of salaries of employees into target table?
how many types of dimensions are available in informatica?
What is meant by pre and post session shell command?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How can we use mapping variables in informatica?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is incremental aggregation?
What is exclusive and normal mode for repository services?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Explain sql transformation in script mode examples in informatica