Data Warehouse Interview Questions
Questions Answers Views Company eMail

what is session partitioning?

1457

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

5 14524

Identifying the bottlenecks in various components of Informatica and resolving them.

1503

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1 3435

what is pmrep command?

1 10802

what happens if the info.server doesn't find the session parameter in the parameter file?

1 4765

Can u access a repository created in previous version of Informatica?

1466

Eliminating of duplicate records without using dynamic lookups

3 6474

what are Lookup caches options? Including persistent caches.

1 4019

Difference between flat files and relational sources?

2 5180

what is session partitioning?

1561

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 6355

Identifying the bottlenecks in various components of Informatica and resolving them.

2168

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

2 7428

what are the different forms of normalization?

2 4760


Un-Answered Questions { Data Warehouse }

Can you suggest us materials for sdtm mapping?

4030


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1527


What is the basic syntax style in SAS?

612


What are the Types of parallelism in detail?

699


Can you explain data flow graph with an example?

707






What are normalization, first normal form, second normal form and third normal form?

621


how to create user defined function (udf) in informatica

781


Explain the etl program with few examples.

541


What are the challenges you faced while making of reports?

484


What is rank metrics in microstrategy?

573


Explain in detail about type 1?

648


How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

525


what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

646


what is the use of proc contents and proc print in sas? : Sas-administrator

600


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1475