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

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

UHG,

4 10963

HI,can one suggest best institute for cognos Training in Hyderabad

14 22523

How to restrict the user to refresh or Run the report only 1 time in BO?

Perot Systems,

6 11295

Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.

TCS,

1 4251

Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.

Cap Gemini, Infinity, TCS,

2 14629

How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.

Cap Gemini, TCS,

1 6400

I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

L&T,

1 15564

What is different between informatica version 8 and 9 version

Cognizant, IBM,

1 3559

I have 5 different country names and their currencies like India-Rupee, USA-Dollar etc. when I run the report, the report should display only either currencies or country names.How to run the report?

L&T,

3 7878

The customer would like to know about his 15days transactions[like 1st day - 15th day]. how would you do this?

L&T,

2 6401

Explain about Microstrategy Report execution process?

L&T,

1 6546

Is it possible to Delete duplicate rows at row level?

2 6938

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2289

Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?

Icon,

1 3326

Intelligent cube is a public object or schema object in microstrategy?

HTC,

3 11046


Un-Answered Questions { Data Warehouse }

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

1654


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.

2798


Hi, If anyone has base SAS certification dumps, please share.

1932


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...................................

2324


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

2100


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)

2790


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1993


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

2480


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

4183


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

2122


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3648


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..

1953


Explain about a time when you discovered a more efficient way to do a work task?

1214


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

8274


How to add default rules in transformer?

1279