Latest Answer: If u r taking connected we return the more than one port, in this we can use the static and dynamic cache and it will support the user defined values.If u r taking unconnected we return the only one port it will support only oracle with this we can use ...
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 (eg:Informatica, Data stage, Abinitio..)Â is for EXTRACTING data from a source systems(a system where client's transactional business information resides) and performing business logic(applying TRANSFORMATION rules) on the collected source information(business ...
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 ...
View page << Previous 1 2 3 [4] 5 6 7 Next >>
Go Top
