Infolinks

Wednesday, 16 May 2012

Scope and Application Interview Questions & Answer


       Scope and Application Interview Questions & Answer   

                ==================================================


1.Question :
------------
What is the result of following query 'select * from po_headers'?

Answers:
--------
It will not return any row because it is just a view. Usually the difference between tables and views are tables are suffixed with 'ALL' like po_headers_all. If you wanna select from the view then you need to setup the Org_id and then you can get the data

You have to set the org_id to retrive data from this view..

begin fnd_client_info.set_org_context('XX'); end;

where 'XX' is the relevant ORGANIZATION_ID for which you want to retrive data from hr_operating_units

2.Question :
------------
What is the difference between 11.5.7 and 11.5.10 versions of oracle applications

Answers:
--------
some new features came like

--forms personalization..etc

3.Question :
------------
Can we look-up a table from source qualifier transformation. ie. unconnected lookup?

Answers:
--------
You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup.

4.Question :
-----------
What is fact less fact table? where you have used it in your project?

Answers:
--------
Fact less table means only the key available in the Fact there is no measures available.

factless fact table means that contains only foreign keys with out any measures example:attendance report of employees in a particular company contains no measures only

5.Question :
------------
What are snapshots? What are materialized views & where do we use them? What is a materialized view?

Answers:
--------
Materialized view is a view in wich data is also stored in some temp table.i.e if we will go with the View concept in DB in that we only store query and once we call View it extract data from DB.But In materialized View data is stored in some temp tables.

6.Question :
------------
What are the various tools? Name a few?

Answers:
--------
A few more
- Cognos Decision Stream
- Oracle Warehouse Builder
- Business Objects XI (Extreme Insight)
- SAP Business Warehouse
- SAS Enterprise ETL Server

Along with the above, need to include the below tools --Informatica --Abintio --DataStage

7.Question :
------------
what customisations you performed in your implementations

Answers:
--------
No answer available currently. Be the first one to reply to this question by submitting your answer from the form below.

8.Question :
------------
Can I post to a parent account?

Answers:
--------
No...Parent account are made in Orrapps which are not posted to your GL, Hence u can not post

9.Question :
------------
What does 'Unfreezing Rollup Groups' do?

Answers:
--------
By unfreezing rolllup group you can make changes to the rollup group. After making changes, you have to freez it again and compile it to get the effect of change.

10.Question :
-------------
Where do we use connected and un connected lookups?

Answers:
--------
If return port only one then we can go for unconnected. More than one return port is not possible with Unconnected. If more than one return port then go for Connected.

If you require dynamic cache i.e where your data will change dynamically then you can go for connceted lookup.If your data is static where your data won't change when the session loads you can go for unconnected lookups

No comments:

Post a Comment