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

Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?

1 3056

What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?

1 3089

We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?

1 2467

Can you have multiple data sources in OBIEE?

1 2917

Do you know about Initialization Blocks? Can you give me an example where you used them?

1 2641

What is query repository tool?

1 3572

Can you migrate the presentation layer to a different server.

2 3915

How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?

1 2643

Why do we have multiple LTS in BMM layer? What is the purpose?

1 3904

How do i disable cache for only 2 particular tables?

1 2875

How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.

1 3579

What is time series wizard? When and how do you use it?

1 1705

What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?

1 2589

 How to sort columns in rpd and web?

2 5482

You worked on standalone or integrated system?

1 3070


Un-Answered Questions { Data Warehouse }

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

2334


How would you format some text using css to be verdana and bold?

1150


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1202


Write the unconnected lookup syntax and how to return more than one column.

1174


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

4265


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 ?

2550


What is dimensional table?

1168


Write the unconnected lookup syntax?

1153


Demonstrate experience in maintaining quality process standards?

2676


Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2176


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2084


Explain in detail about scd type 1 through mapping.

1648


What is rollup component?

1341


what are the data modeling tools you have used?(polaris)

2060


draw informatica architecture 8.6 ?

3949