Data Warehousing Interview Questions

Cache are stored in Repository.

In DWH loops may exist between the table. If loops exist, then query generation will take more time, because more than one path is available. It creates ambiguity also. Loops can be avoided by creatin...

       can any one of u send me the configuration path step by step of cognos reportnet on a computer.

    if possible business objects and informatica with installation and configuration process.

 how to config the servers of informatica and cognos.

it's very urgent pl reply me

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.

Define the variables in Start script and use them in graph. All enviroment variables which have been exported in the shell which is invoking abinitio (  eg. all variables exported in .profile ) will also be available in Abinitio graph.

When we extract the source qualifier haing one option called blob by utilizing that option we can load to target and check in ports mainly

LOB can be trasferred as text in informatica 7.1.2

Subject Area is place where  we draw the entities and attributes of the dimensions and fact table with relationships in ERWIN

Dimension modelling is brokent into subject Areas which are nothing but functional areas of an enterprise.

Take a union transformation and take three working dimensions of three different location  and filter the data and draw a dimension and fact according to specification

Hi Palani,

you define a object(flag) to find out the EMP location on for a particular date/time{he could not able to be in two place at one time }, with use of your time Dimesion write a condition, you will get the Resule

Cheers,

Sithu, sithusithu@hotmail.com

Validation Strategies Data validation strategies are often heavily influenced by the architecture for the application. If the application is already in production it will be significantly harder to bu...

By Using Drill Through we can easily Connect to next report.

Thanks

Mohanraj

using union operator in querrypannel window