⟩ List down some of the real time data-warehousing tools?
ETL:
Informatica,
Abinitio,
Datastage etc..,
OLAP:
Business objects
Cognos,
Micro stragetgy,
Hyperion etc..,
DW:
Oracle,
DB2,
Terradata,
Sybase,
Greenplum etc..,
ETL:
Informatica,
Abinitio,
Datastage etc..,
OLAP:
Business objects
Cognos,
Micro stragetgy,
Hyperion etc..,
DW:
Oracle,
DB2,
Terradata,
Sybase,
Greenplum etc..,
How to do unit testing in informatica? How to load data in informatica ?
Explain What are the mapping paramaters and maping variables?
Why we use repository connectivity?
Explain the Differences between Normalizer and Normalizer transformation?
How to handle decimal places while importing a flatfile into informatica?
What is the difference between Informatica 7.0 and 8.0?
Explain Where to store informatica rejected data? How to extract the informatica rejected data?
Explain How many types of dimensions are available in Informatica?
How to configure mapping in informatica?
What is the difference between informatics 7x and 8x and what is latest version?