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 is the differences between star and snowflake schemas?

1 1142

What are the various methods of getting incremental records or delta records from the source systems?

1 1010

Explain which columns go to the fact table and which columns go the dimension table?

1 985

Explain me what is vldb?

1 994

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1042

Explain the difference between keylokup and joiner?

1 948

Explain what are the various reporting tools in the market?

1 1038

Explain what is analytical or analytic mean?

1 1071

Explain how are the dimension tables designed?

1 1129

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1 1014

What are the various transformation available?

1 1078

Explain a mapping, session, worklet, workflow, mapplet?

1 1160

What are the different types of join operations?

1 1073

Explain what is a three tier data warehouse?

1 1052

Explain piconet?

1 1021


Un-Answered Questions { Data Warehouse }

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2207


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

2306


What is node? How many nodes and amps used in your previous project?

1173


What is aggregate table and aggregate fact table ... Any examples of both?

1118


hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1962


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


how to generate the test data in sas without input data? : Sas-administrator

1202


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104


How do you remove duplicate records in informatica? And how many ways are there to do it?

1232


EXL informatica Questions

1460


What are the data types present in bo? What happens if we implement view in the designer and report?

1082


1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

4260


What is a rollup component? Explain about it.

1242


create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2811