|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions 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 ... Tags : Metadata Latest Answer : Hi,We can extract SAP data by using informatica with the powerConnect option.We need to install and configure the powerConnect tool . Import the Source in to the Source Analyzer. Here PowerConnect is the gateway between SAP & Informatica.Then develop ... Latest Answer : draw the inference if slowly changing dimension and based on the Type 1/2 or3 tables defined. ... I'am new to SAS, can anybody explain the process of extracting data from source systems,storing in ODS and how data modelling is done.RegRam How you capture changes in data if the source system does not have option of storing date/time field How you capture changes in data if the source system does not have option of storing date/time field in source table from where you need to extract the data? The DW database can be Oracle or Teradata. The requirement here is to pull data from source system and ETL need to device a mechanism to identify the changes or new records. The source system can be a Read Answers (1) | Asked by : GeekNo1 Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing maximum sum(salary) group by dept.sources are cobol files / flat files. This is the recent question faced in ibm. Read Answers (3) | Asked by : naresh Latest Answer : Hi, Yes, We Can Test By Using Debugger before u run the session in Informatica ... Read Answers (1) | Asked by : suma In What scenario ETL coding is preferred than Database level SQL, PL/SQL coding? What is the methodology and process followed for ETL testing in Data warehouse environment? Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing... If LKP on target table is taken, can we update the rows without update strategy transformation? How you capture changes in data if the source system does not have option of storing date/time field... What is the Difference between Read Answers (1) | Asked by : srihari Latest Answer : (sources)---------->Staging Area(Transformation)---->Target------>Interface-->ReportsData baseFlat filecobol fileXML file ... Read Answers (1) | Asked by : sainath why we implement sarrogate key in ETL Process? Latest Answer : ETL is not a one time process. It is used to make periodical updates to
dimensional as well as fact data.
Usually dimensions contains lookup data and has less tendency to change, but
if it changes and you want to maintain the change history then ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
