Hi All,
1.How can we use dynamic values in parameter file
ex:-
In post session I am updating 1 table .Before update statement I have to mention connectivity statement like
dbname,username and pwd.Suppose If we move this environment
from dev to QA the connectivity details might be different.
So...
Hi,
1.How can we use dynamic values in parameter file
ex:-
In post session I am updating 1 table .Before update statement I have to mention connectivity statement like
dbname,username and pwd.Suppose If we move this environment
from dev to QA the connectivity details might be different.
So How...
Hi all,
1.Once we complete the mapping how can we test the map.
2.If our session completes succesfully I have to send a
mail to particular group.Suppose if the session rejects some
records then I have to send a mail along with rejected records file in attachments.
How can I do this? Please...
Hi All,
I am doing incremental loading.I created a parameter file
in that file I want store last loaded date.How can I
put that condition.
Now I am using static date like last_load_dt = '20-jan-2005'.But instead of static date I want to populate it dynamically.
Thanks and Regards
Mallik
Hi All,
How can we implement the SCD rule 2 using updatestrategy transformatrion.
I think using surrogate keys we can separate the previous record and current record.
But practically how we can do this.
Please explain step by step
Thank You
Hi,
I want to set the security with in the group also.
Ex:-In 1 group 10 users are there.I want to set the security
with in the users in the same group.So please how we can set
the security.
Thank you.
Sharma
Hi,
Thank You for your reply.
In impromptu i am giving like this
call TEST_PROC1(?i_PROD_ITEM_MODEL_NUMBER? IN)
Error number -9:
DMS-E-GENERAL, A general exception has occurred during operation 'execute'.
ORA-06550: line 1, column 7:
PLS-00201: identifier 'TEST_PROC1' must be declared...
Hi,
I am using Oracle Stored Procedure as a data source in my
impromptu report.In my procedure 1 input and 1 output
is there.So how can I call that procedure in my report
Thank you.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.