How to check the existence of a lookup file in a graph ?
How to check the existence of a lookup file in a graph ..The requriement is if lookup file is present then some search will be carried out in the same else default value will be set. Please note we need to check the existence of the lookup file in graph level only..
How can we do metadata level programming in dml itself to remove blank lines from a file
You can use unix command
sed /^$/d dml_filename > new_filename
Thanks
Aditya
temp file
.rec file contains the information which is required to rollback the graph when it fails
Generally it will have some meta char information with hld and nld extension.
On failure we use to rollback using m_rollback to rollback the job to last committed check point.
By enabling which parameter, dependency analysis feature get enabled
Changes to the above answer ..... In the GDE choose File > Preferences to open the Preferences dialog. Click the Advanced tab, select the Documentation Transforms checkbox and click OK. To set th...
On the GDE menu bar, select File > Preferences.
In the Parameters group of the GDE Preferences dialog, select Document Function.
Open the Properties dialog; in parameter Document Function should be visible.
give the path of .xfr file in AB_DM_DEFS as graph input value parameter.
You can include the transform in test. transer using AB_DML_DEFS in Input Value parameter of Graph..
Data Lineage