What is staging area referring to?
Do we need an etl tool?
Compare etl & elt?
What is tracing level and what are the types?
where is the cache (lookup, index) created and how can you see it.
how do u implement configuration management in Informatica?
explain the methodology of Data Warehousing?(Polaries)
What is cube grouping?
what are the concerns of OLTP and DSS systems?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Explain different types of partitioning?
can cubes contain measures ?
how do u set partition points in the mapping?
where we cannot use sorter Transformation. if we use then we will not get correct data?
what is the use of server?