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

if you use oracle sql*loader , how do you transform data with it during loading?

1 2165

three ways sql*loader could load data, what are those three types?

1 4831

what are the others of "bad files" and "discard files" when using sql*loader?

1 2215

how do you use commit frequencies? how does it affect loading performance?

1 4673

what are the other factors of the database on which the loading performance depend?

1 1973

what is parallelism?

2 5346

what is parallel query?

1 2142

what are different ways of loading data to data warehouse using oracle?

1 5467

what is table partitioning? How it is useful to warehouse database?

EDS, IBM,

1 8653

what are different types of partitioning in oracle ?

3 11708

what is indexing ? what are different types of indexes supported by oracle ?

2 10928

what are different storage options supported by oracle ?

1 2165

what is query optimizer? what are different types of optimizer s supported by oracle ?

ABC,

1 13357

explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I

IBM, Ness Technologies,

3 16676

Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.

iFlex, Wipro,

1 5544


Un-Answered Questions { Data Warehouse }

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212


What sort of existing documents should business analysts refer to when starting on a new project?

1078


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

4260


What is dimensional table?

1162


What are the data types present in bo? What happens if we implement view in the designer and report?

1082


How do you remove duplicate records in informatica? And how many ways are there to do it?

1232


How to add default rules in transformer?

1284


Explain how to generate iqd file from framework manager?

1020


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1849


What is aggregate table and aggregate fact table ... Any examples of both?

1118


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

846


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?

1146


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

1202