Answered by kiran on 2005-05-08 09:20:30: Informatica Metadata contains all the information about the source tables, target tables, the transformations, so that it will be useful and easy to perform transformations
Latest Answer: Metadata is simply documentation for a digital geospatial dataset. It is a text document that describes the who, what, when, where, why and how questions about the data, so that a potential data user can decide whether or not the data is appropriate for ...
Answered by kiran on 2005-05-08 09:32:14: An active transformation can change the number of rows as output after a transformation, while a passive transformation does not change the number of rows and
Latest Answer: Active transformation is nothing but it will change the no of rows passing through it (example) Filter transformation .In it when we have 1000 rows as input after filter transformation according to the condition the output will be modifiedPassive ...
Latest Answer: In a warehouse I would recommend analyzing the data either after each load has completed, or periodically (week-end or month-end) depending upon the data volumes and therefore the effort required. You can analyze a table in Oracle at the Database, Schema ...
Latest Answer: You cannot use Informatica to extract data from SAP via ABAP. Only the SAP/Business Objects Data Integrator product can do this.Informatica uses a data dictionary interface, with clear SQL instructions, example...select BUKRS, BELNR, GJAHR, BUZEI ...
Latest Answer: There are pros and cons of both tool based ETL and hand-coded ETL. Tool based ETL provides maintainability, ease of development and graphical view of the flow. It also reduces the learning curve on the team. Handcoded ETL is good when there is minimal ...
View page << Previous 3 4 5 6 [7]
Go Top
