Data Warehouse Interview Questions
Questions Answers Views Company eMail

For clinical entire study how many tables will create approx?

TCS,

1501

How to read data from flat file source if the data is in paragraph format?

Wipro,

2 3809

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

Wipro,

1891

How to set Parameter in Script data source?

1 1695

How to create a cube in Transformer? What is the process? Please mention process thank u

Genpact,

1307

Unix command to view the data in a dataset

IBM,

2 5546

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

IBM, PR3 Systems,

4 5180

what is the difference between repository & Intergration service

1 3647

hoe to access second value in mapping parameter if it is having more than one value ?????????????

SS Solutions,

1106

What is difference between merged dimension and forced dimension??

1 4002

What is ROWID explain ?

Wipro,

2 3241

when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report

2 2423

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 2819

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1292

Can we make worklet inside worklet?

1 6073


Un-Answered Questions { Data Warehouse }

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

1743


What is the importance of the exception activity in datastage?

592


Which is the database redshift is using?

5


What is a compound attribute in microstrategy?

596


Define slowly changing dimensions (SCD)?

589






Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

538


Explain a relation schema and a relation?

562


Explain transaction control transformation in informatica

733


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6362


What is metric store database?

551


Explain fact constellation schema?

546


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5195


What is application.cfm?

554


what actually happens when bulk load mode starts?

5


What is Redshift Spectrum?

5