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 differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.

Exilant, Wipro,

1 5455

please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.

Wipro,

2 6492

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

iNautix, Wipro,

2260

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

IBM, Patni, TCS,

3 26284

Need Ab-Initio Material - Harini

7 12002

any one pls tell me what are the table names in banking project?

2 5193

any one answer me how they can analyzing the project using data ware housing?

2525

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

TCS,

4605

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!

HCL, Wipro,

5 7987

what is the query for retrieve the unique values(not display the duplicates values) from single table?

IBM,

6 10276

"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

9 12774

Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated

IBM,

1 5255

Hi ,how many shortcut joins used in a single universe? Thanks in Advance

2 5489

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

Infotech,

2194

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

CompuSoft, EDS, TCS,

4 17457


Un-Answered Questions { Data Warehouse }

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

1158


Why are meta service important then other services?

1022


Explain a relation schema and a relation?

1174


What is TPD?

1426


Where is tm1 web logging information found?

5


please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

2250


Which query language is used by amazon redshift?

1


How can you link a query to a data container manually in Report Studio?

2408


How to convert multiple rows to single row (multiple columns) in informatica

1429


What do you mean by data sorting?

1276


What are the table names in oracle database...?

2799


What do you mean by a transaction file?

1305


Diff b/w Crossproduct and Outerjoin?

2338


Define data warehouse?

1104


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2334