Can u access a repository created in previous version of
Informatica?
how do u implement configuration management in Informatica?
what are the facilities provided by data warehouse to analytical users?
how do u implement scheduling in Informatica?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
What are the three tiers in etl?
What is ROWID explain ?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what is SMP AND MPP?
Explain do we need an etl tool?
dimension object created in oracle can be imported in designer?how?
What do you understand by active and passive transformations?