My requirement is like in database some defects are present
and i need to clean them.To be brief for example every
employee should have active assigments.So for those records
which are not having status as active or null ,i need to
update the roecords using API with the correct value.
Client will provide a flat file for the records whch are
defected.So i need to run the API for those records (flat
file)and update the data in database.
So my question is how to handle this requirement.Is there
any existing API for this purpose?If yes then please send
me the NAME.
How to update the records in the database using flatfile.
Any pointer will be appreciated.Thanks in advance.
How can we manage the gap in a primary key column created
by a sequence?
Ex:a company has empno as primary key generated by a
sequence and some employees leaves in between.What is the
best way to manage this gap?
1.what are components of querystdio and report studio and
cognoss connection?
2. how to use prompts in query studio?
3.what is lock and un lock objects?
4.how to test the re[ports in query studio?
5.how to use brust option and when?
6.what is the performance testing?
7.condition explorer whaen your using?
8.in impromptu how do you create cascading prompt?
9.diff between section and group?
10.types filters where you are using group filters and
tabular filter?
11.tabular model, tabular references ,tabular set , tabular sql?
12.what is the use of multi[le packages?
13what types of problems arise when create a join?
14.how to provide package sequirety?
15.report server components?
16.how many kinds of quality subjects?
17.how do you specify the joins?
18.how would you maintain the relations in frame work manager?
19.what is usage of segments and how to provide it?
20.governer settings in frame work maneger?
21.how to create filter in frame work manager?
22diffrence between represention layer and physical layer?
23.how to create prompts in frame work manager?
24.what errors occured when verify the model?
25.how to publish package in net work or local system?
10)In an RDBMS, the information content of a table does not
depend on the order of the rows and columns. Is this
statement Correct?
A)Yes
B)No
C)Depends on the data being stored
D)Only for 2-dimensional tables
9)When information has to be stored w.r.t employees and
their respective departments, which of the following is the
Correct formulation of entries?
A)Employee and department would together be represented as
an entity.
B)This is too less information to decide on entities.
C)An employee would be one entity and a department would be
another.
D)Such a scenario cannot be modelled in RDBMS
Hi,
IN oracle apps HRMS, if the employee changes his department,
and when a conconurrent program is run for calulating the
pay, The latest Dept id is not diaplayed, howeber the
previous deptid is considered. Please can someone tell me
where is the program going wrong, which side?
i have windows-xp processor with P4 system. whenever I
tried to download foxpro for windows 2.6 on windows XP, my
operating system failed to install foxpro for windows
2.6.please. how could i download , install & run foxpro for
windows 2.6 easily on windows XP ?
7
What is the architectural difference between Oracle and SQL
Server 2000?
If I have 100 databases, how many instances get created
when you use Oracle and how many get created when you use
SQL Server?
Hi,
IN oracle apps HRMS, if the employee changes his department,
and when a conconurrent program is run for calulating the
pay, The latest Dept id is not diaplayed, howeber the
previous deptid is considered. Please can someone tell me
where is the program going wrong, which side?
25
in after report trigger if you don't write
Srw.user_exit(Fnd_user exit) what it will do it will stop
report execution or it will just not free the memory
38
Can you convert a bit-mapped report to ASCII
(character-mode) Report ? How ?
can you anybody tell me the how can you restore the master
database. while migraion(one server to onther server)?
15
How well can multiple sessions access the same data
simultaneously ?
34
what is difference between view and Dip.
58
Write a Select Query to display title for each group of
records, which are collected with Compute Clause?
Like
titlefield
column-A column-B .....
.....
.....
Sum
...
titlefield
column-A column-B .....
.....
.....
Sum
...
To Refer this Site to Your Friends 
Site Map