Informatica Corporation is a product organization established in 1993 by Gaurav Dhillon and Diaz Nesamoney. Informatica Corporation is surely understood for its information reconciliation (ETL) item Power Center. A ton of times when individuals say Informatica they really mean Informatica Power Center
Informatica Is a generally utilized ETL apparatus for extricating the source information and stacking it into the objective subsequent to applying the required change.
Through the span of most recent 10 years Informatica has presented a progression of items – all identified with Data Integration and Warehousing. A speedy rundown of Informatica items is right here:
• Power Center
• B2B Data Exchange
• MDM – Master Data Management
• TDM/ILM – Test Data Management/Information Life-cycle Management/Data Archive
• Informatica Data Masking/Dynamic Data Masking
• iPaaS – Integration Platform as a Service
• Informatica Data Virtualization
Since you have a thought regarding the organization and items gives discuss Power A chance to focus.
Informatica Power focus is an incorporation/ETL device. It gets information from various sources (level records or database and so forth) and burdens that information into various targets (level documents or database and so on). It doesn't store anything by any stretch of the imagination. It just moves information starting with one place then onto the next. It has been intended to have the capacity to converse with various types of databases and change information arranges as needs be. By and large you have to change information while moving it and Informatica can do that.
In an information warehousing environment you concentrate on building up a solitary purpose of truth i.e a solitary point where every one of the information is put in incorporated structure. So there are two things
1. You have to get information from various sources . (informatica)
2. You require a last place to store all information taken from better places (Teradata)
3. You should have the capacity to see the consilidated information by questioning it (Teradata)
In the event that you are NOT utilizing Teradata, you wind up utilizing Oracle or SQ server and so on or anyother database
In the event that you are NOT utilizing informatica,
you wind up utilizing PL SQL, Datastage, Abinitio or some other ETL instrument.
Informatica resemble a transportation vehicle. It moves things around.
Teradata resemble a distribution center..
Informatica Is a generally utilized ETL apparatus for extricating the source information and stacking it into the objective subsequent to applying the required change.
Through the span of most recent 10 years Informatica has presented a progression of items – all identified with Data Integration and Warehousing. A speedy rundown of Informatica items is right here:
• Power Center
• B2B Data Exchange
• MDM – Master Data Management
• TDM/ILM – Test Data Management/Information Life-cycle Management/Data Archive
• Informatica Data Masking/Dynamic Data Masking
• iPaaS – Integration Platform as a Service
• Informatica Data Virtualization
Since you have a thought regarding the organization and items gives discuss Power A chance to focus.
Informatica Power focus is an incorporation/ETL device. It gets information from various sources (level records or database and so forth) and burdens that information into various targets (level documents or database and so on). It doesn't store anything by any stretch of the imagination. It just moves information starting with one place then onto the next. It has been intended to have the capacity to converse with various types of databases and change information arranges as needs be. By and large you have to change information while moving it and Informatica can do that.
In an information warehousing environment you concentrate on building up a solitary purpose of truth i.e a solitary point where every one of the information is put in incorporated structure. So there are two things
1. You have to get information from various sources . (informatica)
2. You require a last place to store all information taken from better places (Teradata)
3. You should have the capacity to see the consilidated information by questioning it (Teradata)
In the event that you are NOT utilizing Teradata, you wind up utilizing Oracle or SQ server and so on or anyother database
In the event that you are NOT utilizing informatica,
you wind up utilizing PL SQL, Datastage, Abinitio or some other ETL instrument.
Informatica resemble a transportation vehicle. It moves things around.
Teradata resemble a distribution center..
No comments:
Post a Comment