Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Data Warehouse Interview Questions
Questions Answers Views Company eMail

what are the differences between proc report and proc tabulate?

3 20931

is there any differnce between proc means and proc summary?

5 9394

1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.

1 8483

1)what is the use of Deployement and Scheduling? 2)If you have a prompt in your report , after scheduling the report will it run? 3)How can we move our reports from one Environment to Another Environment? 4)What is the complex report in your project and whar are the critical issues have u faced in u r reports and tell me name of some recent reports have u created? 5)What are the limitations of value prompts?

IBM,

2 6710

What is Dynamic Grouping? what is diff between grouping n levelspan?

CybAge,

2 9323

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

2236

What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?

Cognizant, Niteo, SacSoft,

1 5453

How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?

AIG, Niteo,

1 6695

how to join the two flatfiles using the joiner t/r if there is no matching port?

Cegedim,

5 13635

What is the difference between Conditional Layout and Conditional Block

TCS,

1 11249

What is the diff between Drill through reports and Master detail reports?

CSC, TCS,

2 9388

1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.

1 5135

what are the complex reports you have created. Tell me with example?

Insurance, TCS,

7 33514

while migrate bo 5.1 report into boxir2 ,what are the problems faced

2 7123

There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?

2 7711


Un-Answered Questions { Data Warehouse }

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

2020


What is the difference between router and filter?

1269


What is workflow manager?

1047


How to test the debugging in sas?

1179


What is the purpose of using case expression in teradata?

1017


How can repository reports be accessed without sql or other transformations?

1218


How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1099


Explain what is the use of proc gplot?

1198


What is a local lookup?

1221


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2228


What is joiner transformation in informatica?

1045


what is enterprise guide? What is the use of it? : Sas programming

1021


What is dimensional table?

1062


How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2271


Differences between where and if statement?

1090