Hi ,
any one can help me on the same,this is regarding the
Informatica Function doc,i want to know how developer is
will develop the mapping. pl forwar the any function
doc .just for my references.
svlc75@yahoo.co.in
in user parameter property we have list of values.can we
write select query for binding? for example:: select empno
from emp where deptno=:deptnum :deptnum is first parameter
it displays distinct dept nos. if i do like this it is
giving error:: bind variables are not allowed in the select
statement
HI in report builder am creating paramters.for that i have
taken emp table from scott user . in deptnum am displaying
distinct deptno.if i select dept 10 ,empnum drop down
should display empno's of deptno 10. .if i select dept
20 ,empnum drop down should display empno's of deptno
20.for this wat i have to do.
in reports 1og.if we enter a query in list of values then
parameter form displays a dropdown.in that if any ething is
selected then that will display in the report.supp if i am
not selected any value then it should display all the
values.how it is possible?can any one help me........
Give two methods you could use to determine what DDL
changes have been made.
51
what is the role of auditor in auditing data oriented
applications?
39
what are the API of GL,PO,AP
47
What view would you use to look at the size of a data file?
58
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
explain about the critical recovery scenario you had
experienced
60
what is the scripts in data base?
19
Which types of backups you can take in Oracle?
2. A database is running in NOARCHIVELOG mode then which
type of backups you can take?
3. Can you take partial backups if the Database is running
in NOARCHIVELOG mode?
46
Can you give me some DBCC command options?(Database
consistency check) - DBCC CHECKDB - Ensures that tables in
the db and the indexes are correctly linked.and DBCC
CHECKALLOC - To check that all pages in a db are correctly
allocated. DBCC SQLPERF - It gives report on current usage
of transaction log in percentage. DBCC CHECKFILEGROUP -
Checks all tables file group for any damage.
Q1:code to connect to sql server(database) through jdbc
application.
Q2:code to connect to Mysql(database) through jdbc application.
Q3:code to connect to oracle(database) through jdbc application.
26
what are the things that you consider while creating indexes
on partitioning tables?
25
How can you plan the logshipping before processing?
does the query needs a hint to access a materialized view?
32
You have modified 100 store procedures and want to
replicate these changes from development to prodution, and
production can have users using the Server/DB, how would
you replicate without causing issues?
25
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
147
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
43
how the indexes are stored in the Oracle Database?