interview questions

[efulgent]

hi,
can any one please send interview questions on microstrategy and
businessobjects.

thanks
naveen

[kishleo]

hi guys,
here i am attaching a word file with informatica question, if you think there is any question you can add, just update and upload it... hope this file helps someone
thank you

[kishleo]

Hope it will helpfull for someone, soon (may be next week) i will post questions on datastage.
thank you all

Hello kishleo,
Thank you very much for the questions. However in future to upload documents like these use this link http://www.exforsys.com/component/op...wform/formid,3

I have deleted the post that contains interview questions for informatica and I shall upload these questions in our question bank site http://qb.exforsys.com as soon as possible. Once again, thanks for the questions and welcome to exforsys

Regards,
Admin @ Exforsys, Inc.

Post edited by: admin, at: 2004/09/20 07:41

[mangalsachin2002]

hi everybody!

i would like to congratulate exforsys for starting this new learning series on datawarehousing.. i have gone through the first two tutorials.. the language is quite easy and simple.. i have some queries about it:

1. r u also going to give tutorials on how to use specific tools like informatica, datastage, etc.?
2. in total how many tutorials u r going to give about datawarehousing and within how much time u will cover all these tutorials?
3. wat is the full form of OLTP? wat is the difference between OLAP and OLTP?
4. when conventional datawarehousing is able to handle and answer complex queries than wat is the need of OLTP and OLAP?

thanks

[sanereddy]

1. r u also going to give tutorials on how to use specific tools like informatica, datastage, etc.?

We will be covering the topics mentiorned in the training details article unless some one willing to help with the tutorials in tools like informatica, datastage. We are trying to hire someone who can build these for us.

2. in total how many tutorials u r going to give about datawarehousing and within how much time u

We are trying complete complete course in 2 months, I guess it will be more then 100 tutorials covering all the aspects of MSAS.

3. wat is the full form of OLTP? wat is the difference between OLAP and OLTP?

OLAP : A tool to evaluate and analyze the data in the data warehouse using analytical queries. A tool which helps organize data in the data warehouse using multidimensional models of data aggregation and summarization.
Supports the data analyst in real time and enables online analysis of data with speed and flexibility.

OLTP:
Designed for real time business operations.
Optimized for a common set of transactions, usually adding or retrieving a single row at a time per table.
Optimized for validation of incoming data during transactions; uses validation data tables.
Supports thousands of concurrent users.

These 2 will be convered in our training series in detail

4. when conventional datawarehousing is able to handle and answer complex queries than wat is the need of OLTP and OLAP?

Designed for analysis of business measures by categories and attributes
Optimized for bulk loads and large, complex, unpredictable queries that access many rows per table.
Loaded with consistent, valid data; requires no real time validation
Supports few concurrent users relative to OLTP


Again, all these are covered in the tutorials, why and how you should select.


Let me know if you have any questions,

[dwh]

Hi all,

After spent quality time I found I am at right forum. I like to verify Is following the road map to dataware house architecture?

Learn:

data structure
set theory
predicable logic
data bases
data modelling
data ware house architecture

Wish to get information abt:

How much costs for training for each tool.. Any good training institute in pune. Any certification. How long will course(s) take? What is the current market and trend for DW? Any DW user group in Pune? Any DW virtual user group? how a novice get into DW?

Thanks and Regards,
Treasure

[smithamd]

Hi,
Can you please give me the link for datawarehousing tutorials. I am not able to trace it.

Thanx

[katragadda_swetha]

hi
can anyone plz send me interview questions in informatica....

[shashi5]

hi shwetha here are some questions for you
1 What is a staging area? Do we need it? What is the purpose of a
staging area?


2 When do we Analyze the tables? How do we do it?


3 What is the difference between Power Center & Power Mart?


4 What is partitioning? What are the types of partitioning?


5 What is latest version of Power Center / Power Mart?


6 What is Informatica Metadata and where is it stored?


7 What is Full load & Incremental or Refresh load?


8 What is a three tier data warehouse?


9 What is a mapping, session, worklet, workflow, mapplet?


10 What are the various transformation available?


11 What are the various tools? - Name a few


12 What are the various methods of getting incremental records or
delta records from the source systems?


13 What are the modules in Power Mart?


14 What are the different Lookup methods used in Informatica?


15 What are snapshots? What are materialized views & where do we use
them? What is a materialized view log?


16 What are parameter files ? Where do we use them?


17 What are active transformation / Passive transformations?


18 Techniques of Error Handling - Ignore , Rejecting bad records to
a flat file , loading the records and reviewing them (default values)


19 How to determine what records to extract?


20 How do we extract SAP data Using Informatica? What is ABAP? What
are IDOCS?


21 How do we call shell scripts from informatica?


22 How can we use mapping variables in Informatica? Where do we use
them?


23 Do we need an ETL tool? When do we go for the tools in the
market?


24 Compare ETL & Manual development?


25 Can we use procedural logic inside Infromatica? If yes how , if
now how can we use external procedural logic in informatica?


26 Can we override a native sql query within Informatica? Where do
we do it? How do we do it?


27 Can Informatica load heterogeneous targets from heterogeneous
sources?