Hello,
I need help on passing parameter to Oracle Stored
Procedure.I am a oracle DBA,need to use some graphs.
I need help to pass date parameter with format YYYYMMDD
from Ab Initio to Oracle STored Procedure.How to do that
please explain me...
Answer / cse70938
RUN SQL COMPONENT
exec proc-name (parameters)
exec proc-name ('$DATE')
exec proc-name ('20080101')
| Is This Answer Correct ? | 10 Yes | 2 No |
What do you mean by data sorting?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
What is the difference between sandbox and EME?
What is m_dump?
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
What the difference between “look-up” file and “look is up” in abinitio?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
What is the syntax for m_dump in abinitio?
What do you mean by the overflow errors?
What are “business rules” in ab initio business rules environment (bre)?
What is difference between force_error & force_abort? How to use in abinitio graph?