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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

Enterprise data warehouse your projects phase by phase explain?

Cap Gemini,

1477

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

ABC, Cap Gemini,

4 8581

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

Logica CMG,

3 9932

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

Logica CMG,

3 7097

How to add source flat file header into target file?

Logica CMG,

3 7640

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

TCS,

7683

Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.

 7 8660

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

DELL,

1 7017

where we cannot use sorter Transformation. if we use then we will not get correct data?

 1808

Does Facttable Normalized or Denormalized?

IBM,

2 7253

Any body help me...what are challenges did u face in Business object project?

 1 4166

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

Cap Gemini,

7 10986

we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??

 1 4745

we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??

 4 7292

Informatica and datawarehousing courses in Pune?

 2 4529

Un-Answered Questions { Data Warehouse }

Have you used rollup component? Describe how.

666

Define query studio?

601

In how many ways we can create ports?

710

Explain snowflake schema?

586

Explain degenerate dimension table?

550




How do you convert single row from source into three rows into target?

613

What are the types of facts in microstrategy?

624

What are session timeout and application timeout? Where we have to do this process?

608

what are several options for creating reports in web report studio? : Sas-bi

636

what is the difference between filter and condition?

613

How we can create SAS USER DEFINED CODE?

1618

How do you define Teradata?

614

----------------Diff b/w Dimensional modeling and Relational modeling?

13923

How would you configure wh authentication?

562

Explain vldb?

637

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