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
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA.
How do you implement the concept of reusability in Microstrategy?( As in Informatica it is done by creating mapplets.)
Latest Answer: Informatica Metadata Exchange (MX) provides a set of relational views that allow easy SQL access to the Informatica metadata repository. The Repository Manager generates these views when you create or upgrade a repository. MX views provide information ...
Latest Answer: ETL tool is used for Extration ,Transformation(filtering) and loading the data into data warehouse .OLAP tools are used to analitical purpose basically for report generation i.e to retrieve the data from dataware,OLAP is multidimensional model. ...
Latest Answer: ODS is nothing but operational data source. It contains most recent data .it contains around 30-60 days data It is placed in between source system and staging area.. reports can also be taken in ODS . ...
Latest Answer: You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup. ...
Latest Answer: Hi!Lookups are two types: 1) Connected 2) Unconnected
Connected is further two types 1) Static 2) Dynamic connected lookup is used while returning single or multiple returning values, but unconnected can return only single return value. static and dynamic ...
Latest Answer: Parameter files are used for static variable exectuion of a task. this file can b modifies/updated for later change in the parameter. say for ex, xyz="RAJAT" is defined in the parameter file and now whererever XYZ is used in the mapping the ...
Latest Answer: with out knowing these what can u do? ...
View page << Previous 1 2 3 [4] 5 6 7 Next >>
Go Top
