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

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 4305

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

Systime,

1 18248

Hai..,in datastage how to explain project in interview?please explain any domain please.

Wipro,

1 13806

what is the difference between sas and other datawarehousing languages?what are the advantages of sas over them?

Accenture, Infosys,

2 9425

How can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema ?

1 5515

what is crosstab reporting,slice and dise and drill mode??

3 12683

when we go for unconnected lookup transformation? and why?

Accenture,

5 14729

why we use source qualifier transformation?

Accenture,

16 47077

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

L&T,

4 18233

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

L&T,

8 22872

WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?

GE,

2 9349

1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com

IBM,

1 6512

What are the challenges of Dataware housing in the future?

HP,

2 8317

Which gives the more performance when compare to fixed width and delimited file ? and why?

HP,

3 13927

Explain about derived tables?

Cap Gemini,

2 8947


Un-Answered Questions { Data Warehouse }

What is level based metrics.how will you create it?

943


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4793


what are the uses of fact table and dimension table in banking project?

4605


how to generate the test data in sas without input data? : Sas-administrator

1188


What is the command in bteq to check for session settings ?

1241


When we use aggregate awareness function in designer?

1026


Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1099


Explain 4gt switch. Does it have any drawback?

1021


Explain what are the possible data marts in retail sales?

1061


What is the difference between connected and unconnected stored procedures?

1155


What is the purpose of having stored procedures in a database?

1228


Explain scd type 3 through mapping.

1061


A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2275


Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1843


Describe the between keyword in teradata?

1091