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

what type of reports you are generating in your company...???

GSK GlaxoSmithKline,

2 6494

if we dont want to print output what we have to do..???give syntax..???

Accenture, GSK GlaxoSmithKline,

8 16717

What are aggregate fact tables ? why they are needed? give an example

2 10840

State any 5 of Cods guidelines of an OLAP system, brief description each?

1 7305

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

Cap Gemini, Wipro,

10 19381

how to improve performence by using sorted input in aggrigator t/r.

2 6171

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 6691

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

Cap Gemini,

2 10140

Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 4691

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

Cap Gemini,

5 15717

how to create document in datastage?

Cap Gemini,

1 7220

how to transfer file from one system to another system in unix? which cmd to be use?

Cap Gemini,

5 15961

What is the difference between Boxir2 and Boxir3?

1 9029

wha is the difference b/w merge dimension and combining two different data providers?

1 5687

Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?

1 2774


Un-Answered Questions { Data Warehouse }

Demonstrate experience in maintaining quality process standards?

2658


explain in detail about type 3?

1078


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

4011


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

6056


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)

2790


What is dimensional table?

1145


can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2324


draw informatica architecture 8.6 ?

3939


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

3648


how many reports have u created ? explain a few.

2152


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

2289


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1654


1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

4248


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

1167


What r the names of the reports that you prepared?

1023