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

/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance

Eval Source,

2 4503

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

1 2571

Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

Infosys,

3 7615

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 3971

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

HP,

2267

How to prepared lld.can any one tell me detailed explanetion.

Bank Of America,

2052

hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

Polaris,

1 3698

how to load meta data

IBM,

2 4568

I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?

2 3758

Are you aware of any limitations in Cognos?

HCL,

1 3111

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

CTS,

2 9882

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

Wipro,

4 8504

i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance

Tech Mahindra,

2 5048

In which case u go for libname and in which case u go for proc sql pass thru facilit diff?

1 3703

I have a dataset with variables empid and doj how to calculate retirement age?

1 4020


Un-Answered Questions { Data Warehouse }

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

2303


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

1233


Write the unconnected lookup syntax?

1152


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

1150


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

2306


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796


Are you involved in writing the inferential analysis plan? Tables specifications?

4019


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

1224


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)

2795


how many reports have u created ? explain a few.

2162


Explain how to generate iqd file from framework manager?

1022


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

1178


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

2306


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1852


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1200