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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

what is the difference between breaks and sections?

IBM,

3 7134

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

DELL, iGate,

2 8321

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

 3307

I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

IBM,

1 4686

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

 1628

how to generate means for every subject;

Mind Tree,

4 6031

how to change the execute of macro

Mind Tree,

1658

how to generate report for 0 observation dataset?

Mind Tree, Student,

3 5629

"What is the difference between proc sort nodup and proc sort nodupkey?"

 2 5950

What are the types(Specific Names) of Scheduling in BO?

Cap Gemini,

3 9349

What is Array bind size in universe? Plz

TCS,

2 17935

What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.

Collabera,

3 6684

what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

TCS,

1 6438

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

TCS,

3 6815

what is the difference between informat$8. $char8.

SAS,

3 11565

Un-Answered Questions { Data Warehouse }

Explain the difference between union and group?

616

Is hadoop a etl tool?

505

how you migrate reports to cognos 8 from previous versions?

619

Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3142

What is drilling across?

549




What is the SAS data set?

667

Explain the architecture of obiee and what each components do?

481

What are the differences between different versions of co-op?

566

What is a dimension table?

602

What are the table names in oracle database...?

2238

what is slowly changing dimension? : Sas-di

609

Can you explain dynamic query mode?

575

how does sas handle missing values in assignment statements? : Sas programming

563

what is program data vector? : Sas-administrator

602

What is derived metric?

581

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