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

How many universes will run maximum in single project

HP,

1 3916

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

Infosys, Wells Fargo,

1 4454

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

Amex,

2 4655

What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples

NTT Data,

2 4605

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 15595

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

HCL,

1 3679

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

CTS,

2 4679

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

HCL,

1 5014

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

HCL,

4 7326

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

TCS, Wipro,

4 7918

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

TCS, Wipro,

1 2078

How to move data set from one server to other?what are the steps to follow to do this?

2 4735

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 6406

why less number of records in loop? why more number of records in traps?

Wipro,

1 3513

Can we create datasets by proc step ? (Proc contents, Means)?

2 4082


Un-Answered Questions { Data Warehouse }

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

1964


Explain scd type 3 through mapping.

1076


what are the dimensions that you have in your current project?list them?

2095


faq's on cognos

4113


Write the unconnected lookup syntax?

1152


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6077


What is a rollup component? Explain about it.

1245


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

3664


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

1852


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

1233


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 ?

2549


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

1178


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212


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

2107


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

2213