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 5371

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 6395

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,

2232

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 26146

Need Ab-Initio Material - Harini

7 11800

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

2 5107

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

2483

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

TCS,

4559

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 7839

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

IBM,

6 10056

"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 12471

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 5165

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

2 5399

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,

2135

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 17310


Un-Answered Questions { Data Warehouse }

Explain the scenario which compels informatica server to reject files?

1172


i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2696


In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1041


What are the available join types in teradata?

1073


Explain the different types of data warehousing?

995


How can you limit the variables written to output dataset in data step?

1321


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1328


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2188


What are the supported languages for microstrategy intelligence server?

1021


what is the difference between == and eq in UNIX shell scripting?

1502


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2130


define under feeding?

5


Could any one explain me how to create cascading prompts?

1071


how does rules tracer help us?

5


Demonstrate experience in maintaining quality process standards?

2560