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

Please write codes to merge two datasets and keep every record in the first dataset.

1 4929

When merging 2 datasets with a common variable (not merge key), how to keep both?

3 7227

Write a SAS macro to calculate number of numbers in an email address

2 6587

Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.

2 7365

Can i create a lookup table without cache.

iGate,

7 11966

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

iGate,

1 2270

whats the logic to load the lower level of granularity of data to fact table.

IBM,

1 2334

What exactly mentioned in High level design document.can somebody explain me sequentialy.

IBM,

1 6757

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

IBM,

2 5938

How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

IBM,

1 3625

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

iGate,

1 5813

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 5599

how to find out number of records imported into source file?

1 6897

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?

Cap Gemini,

4 12678

how to prepare the documentation in business objects and where to get the requirement?

IBM, TCS,

1 2299


Un-Answered Questions { Data Warehouse }

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

1082


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

1173


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


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

2127


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342


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

1215


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

1670


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2436


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


What sort of existing documents should business analysts refer to when starting on a new project?

1078


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167


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


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2546


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

1150


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

2306