1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

Where are the source flat files kept before running the session?

Informatica,

721

Informatica settings are available in which file?

Informatica,

685

What is option by which we can run all the sessions in a batch simultaneously?

Informatica,

757

How to update or delete the rows in a target, which do not have key fields?

Informatica,

758

What is a repository? And how to add it in an informatica client?

Informatica,

773

Name at least 5 different types of transformations used in mapping design and state the use of each.?

Informatica,

781

How to create the source and target database connections in server manager?

Informatica,

706

What is the purpose of Dataware Control?

CGI,

678

What steps should be taken to improve Datastage jobs?

 723

In Datastage, how you can fix the truncated data error?

 731

Name the command line functions to import and export the DS jobs?

 807

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

 720

Define Merge?

 983

Explain Quality stage?

 769

Explain how a source file is populated?

 927

Un-Answered Questions { Data Warehouse }

On which Dimension Table you implemented SCD Type in your Project

1683

Difference between nodup and nodupkey options?

737

how would u estimate the size of Aggregator transform data and index cache?

2089

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

568

Differentiate between reusable transformation and mapplet.

698




What are the possible data marts in retail sales?

639

Explain informatica architecture - version 8 / 9

757

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2010

In Datastage, how you can fix the truncated data error?

731

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

663

what is the effect of the options statement errors=1? : Sas programming

685

how to merge 2 crosstabs thans

2244

name several ways to achieve efficiency in your program? : Sas programming

671

Imagine this, you are required to reset the password for all users at a time. How would you do that?

629

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1591

For More Un-Answered { Data Warehouse } Questions Click Here