dimension object created in oracle can be imported in
designer?how?
What is granularity? Please explain with example
What are cubes and olap cubes?
how would u estimate the size of Aggregator transform data and index cache?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What are the three tiers in etl?
what do u do when DB time takes more?in sap bi
Compare ETL & Manual development?
What are snapshots?
what is the difference between cardinality and Nullability?
SCD2 will work on only dimension tables as well as fact Table?