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

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

1 1096

What is the extension of file to save template?

1 1081

Explain normalization?

1 1228

How to get the first 100 rows from the flat file into the target?

1 1278

Explain why dimenstion tables are denormalized in nature?

1 1001

Explain what are components of report studio?

1 1192

Explain what is metadata reporter?

1 1048

What are the advantages and disadvantages of reporting directly against the database?

1 1044

Explain what is difference between query studio and report studio?

1 1062

Explain ddl (data definition language)?

1 1064

Explain how to generate iqd file from framework manager?

1022

How to limit the max no of rows retrieved in the report?

1 1052

Code the tables statement for a single-level (most common) frequency?

1 1000

What is perform recovery?

1 1220

Can we start and stop single session in concurent bstch?

1 1004


Un-Answered Questions { Data Warehouse }

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8286


i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2767


What is dimensional table? Explain the different dimensions.

1269


Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2094


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2127


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


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

1118


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1670


Explain how to generate iqd file from framework manager?

1022


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.

2813


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2260


how many reports have u created ? explain a few.

2160


How would you format some text using css to be verdana and bold?

1150


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

846


Have you have ever worked in unix environment and why it is useful in datastage?

1215