what is the difference between ab_work_dir and .work
Answers were Sorted based on User's Feedback
Answer / rajat singh
AB_WORK_DIR
Specifies the storage directory for temporary files written by the Co>Operating System when running a job.
When you run a graph, the Co>Operating System creates .WORK directories in the directories of the layouts of program components. During the execution of the graph, if components need to write temporary files, the Co>Operating System creates unique subdirectories in the appropriate .WORK directories, and the components write files in these unique subdirectories. The locations of the .WORK directories are based on the layout of a program component
| Is This Answer Correct ? | 19 Yes | 0 No |
Answer / abhishek
AB_WORK_DIR specifies the storage directory for temporary
files written by co-operating system when running a job. It
is a configuration variable whose value is a working space
for graph execution. It maintains the information related
to graph recovery.
In most cases, temporary files are maintained in the .WORK
subdirectory of a component’s layout. But when you use host
layouts or database layouts, which lack directory paths, or
when you use unwritable layout directories, the data is
written to a subdirectory of AB_WORK_DIR.
| Is This Answer Correct ? | 4 Yes | 0 No |
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
How is the partitioning with key different from round robin partition?
What is the best way of creating huge test feeds?
what is the difference between the .dbc and .cfg extensions and give any clear information ?
Mention what dedup-component and replicate component does?
What are the various types of layout supported by abinitio?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
Output for sort and dedupsort with NULL key?
Have you used the rollup component? Describe how?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
Difference between public and private projects and how to make private to public?
What is conditional DML and Structured DML?