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

how change the order of prompts in bo xi? eg. i create first prompt with 'year' and second prompt with 'city'. my question is to display the 'city' prompt first .what can i do for it ?

Cambridge, Patni,

3 12687

The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;

Accenture,

1 5721

how get the grand total in master-detail report?

Patni,

2241

what is a force compile

Cap Gemini, IBM,

2 9166

what is a message handler

IBM,

3 10867

what is the use of invokation id

IBM,

2 10979

what is a nodemap constraint

IBM,

2 13384

how can we load starting with 11th record of a table from source to target

IBM,

6 10836

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

IBM,

2 6847

can we load the data with out a primary key of a table? what is target plan?

IBM,

6 15214

what is normalizer transformation?

Wipro,

4 7941

What is proc sql pass through facility?

L&T,

4 9784

how eliminate the duplicates in flat file with out using sorter ,aggregater

Wipro,

4 11310

how to load dimension table and fact table. plz tell me the steps.

Cognizant, IBM,

2104

how to load the data to fact table?

2716


Un-Answered Questions { Data Warehouse }

What is the difference between match merge and one to one merge?

1262


Why do you need stage variables?

1189


How to implement security measures using repository manager?

1190


10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?

2509


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1062


what are some differences between proc summary and proc means? : Sas programming

1143


What is partitioning? Explain different types of partitioning?

1252


Explain etl mapping sheets?

1087


Name the types of gateway?

1020


What is the extension of file to save template?

1013


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2428


what is the limit of string length in turbo integrator?

5


Differentiate between sessions and batches?

1027


Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

2014


Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

1385