Monday, February 24, 2014

DRY RUN in DAC

DRY RUN :-
DRY RUN IS AN OPTION THAT BASICALLY RUNS AN EXECUTION PLAN WITHOUT INVOKING ANY INFORMATICA WORKFLOWS.
IT BASICALLY ALLOWS YOU TO CHECK AND TEST THE TASK EXECUTION ORDER.
NO ETLS WILL ACTUALLY BE EXECUTED ON A DRY RUN.


YOU CAN TRY NORUN OPTION. WHEN SET TO TRUE, THIS PROPERTY WILL RUN THE EXECUTION PLAN FOR JUST GENERATING
THE TASKS AND THEIR DETAILS.
NONE OF THE TASKS WILL BE EXECUTED, AND THE REFRESH DATES WILL NOT BE UPDATED. USE THIS ONLY TO DEBUG.

DAC ->SETUP-> DAC SYSTEM PROP-> QUERY FOR 'NO RUN' PROPERTY AND CHANGE ITS VALUE TO TRUE.


DRYRUN
POSSIBLE VALUES ARE TRUE AND FALSE.
INDICATES WHETHER TASKS ARE EXECUTED WITHOUT INVOKING INFORMATICA WORKFLOWS.
THE FOLLOWING PROCESSES ARE EXECUTED: CHANGE CAPTURE, TRUNCATION OF TABLES, DROP AND CREATION OF INDICES,
AND ANALYZE STATEMENTS.
NOTE:  THIS OPTION SHOULD BE USED FOR DEBUGGING PURPOSES ONLY AND NOT USED IN A PRODUCTION ENVIRONMENT.

No comments:

Post a Comment

 BEST PYSPARK LEARNING SITES https://www.youtube.com/watch?v=s3B8HXLlLTM&list=PL2IsFZBGM_IHCl9zhRVC1EXTomkEp_1zm&index=5 https://www...