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

When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

Accenture,

2 8569

If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?

Accenture,

10 20582

Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables.

Accenture,

7 16224

How would you delete duplicate observations?

Accenture,

10 33298

How would you delete observations with duplicate keys?

Accenture,

13 27089

How would you code a merge that will keep only the observations that have matches from both sets.

Accenture, Bank Of America,

5 14760

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 set to a second data set, and the non-matches of the right-most data set to a third data set.

Accenture,

10 19003

What is the Program Data Vector (PDV)? What are its functions?

Accenture,

5 25254

Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Explain.

Accenture,

4 21475

At compile time when a SAS data set is read, what items are created?

Accenture,

14 31236

Name statements that are recognized at compile time only?

Accenture,

3 9810

Identify statements whose placement in the DATA step is critical.

Accenture, Labasol,

6 12016

Name statements that function at both compile and execution time.

Accenture,

7 25821

Name statements that are execution only.

Accenture,

14 24405

In the flow of DATA step processing, what is the first action in a typical DATA Step?

Accenture,

6 19014


Un-Answered Questions { Data Warehouse }

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4192


What is a rollup component? Explain about it.

1241


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2060


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2084


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2792


how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2175


can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2334


how many reports have u created ? explain a few.

2160


Demonstrate experience in maintaining quality process standards?

2672


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2492


What is dimensional table? Explain the different dimensions.

1267


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2149


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1239


what is document design in boxi,have u participate in that

2305