what happens if the info.server doesn't find the session parameter in the parameter file?
Explain do we need an etl tool? When do we go for the tools in the market?
what is the use of structures?how many nodes can u create in a structure?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
what is the difference between cardinality and Nullability?
What is full load & incremental or refresh load?
what are the concerns of OLTP and DSS systems?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
What is a mapping?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Explain me ETL project architecture in Detail?
What is staging area referring to?
What are snapshots?
What are dimensions?
flat filevalidation in informatica