How can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause whenever u select the source data in informatica it shows it can take only character data
Any one help and answer me for the following question?Question : One employee is working in three different locations. Frequently, the employee changes his work location. Using n-n relationship, how to identify the employee's current location? or how to draw fact table and dimension tables relationship for this concept?
How many clustered indexes can u create for a table in DWH?In case of truncate and delete commanda what happens to table which has unique id.
Latest Answer : Error Log in Informatica is a one of output file created by Informaica Server while running the session for error messages. It is created in Informatica's home directory. ...
After we create a SCD table can we use that particular Dimension as a dimension table for Star Schema.
1) what is datawarehouse architecture?2) Informatica Architecture?3) what is unit testing?4) what is type2 version dimension?
Which of the following technology gives highest near real time ETL performance?Informatica RTAb Initio CFDatastage CDCSocket Programs
Implementing a referential integrity in DW environmentSupports analytical performance in the databaseCreates issues in fact loadingSupports implementing a table for each dimension attributeResults into analytical performance issues
“A dimension table is wide but the fact table is deep” Explain the statement in your own words.
Latest Answer : Aggregate tables are pre-computed totals in the form of hierarchical mutidimensional structure.,whereas materliazed view ,is an database object which caches the query result in a concrete table and updates it from the original database table ...
