interview questions

[caradoc]

You can have the data warehousing tutorials from this site:

http://www.geekinterview.com/Intervi...Data-Warehouse

[caradoc]

Here are 2 links that you can get tutorials from:

Geek Interview and
IT Question Bank

[sheetal dhore]

Originally Posted by 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?

[ramprasadsingh]

hi.

anybody please send me the datawarehousing and informaticaa tool interveiw quiestjions with solutions
plz recognize my request.

[zsk_00]

Thanks caradoc. Geek Interview looks good.


zafar

[coolbee_chinna]

hi...can anybody provide the answers for the above questions????

[mohammad_ismail]

hi,

I have just installed Informatica in my system on win2000 i am unable to start the informatica server, can any one help me plz and let me know how to solve this problem
thanks

[mohammad_ismail]

hi chinna if you have got the answer to the question you have placed plz let me know.
thanks

[coolbee_chinna]

hi ismail!!!!
i didnt get the answer for that..
but,do u have any realtime projects in informatica?
if u have, can u share them with me...
bye
chinna

[mohammad_ismail]

hi all

I have installed Informatica 7.1.1 on +oracle 9i+windowsXP the informatica services stop as soon as it starts its says "SOME SERVICES STOP AUTOMATICALLY" so how to resolve this problem ur help will be app

thanks
mohammad