How to get the counts of deleted files in unix/linux If you want to get the deleted files count by your rm command, use the verbose option (-v) and wc… Continue reading How to get the counts of deleted files in unix/linux
Tag: Informatica BDM
How to find all writable files by a specific user in unix
Linux find command to list all files writable by a specific user To find all writable files in current directory that are writable by the current user: use the command… Continue reading How to find all writable files by a specific user in unix
How to read comma separated data within double quotes in a csv file in Informatica BDM
In real world, most of the csv file will have comma separated data field which will enclose in a double quotes. When you read such kind of file in Informatica… Continue reading How to read comma separated data within double quotes in a csv file in Informatica BDM
How to skip header record and read only data records in a flat file in Informatica BDM
If you have a comma separated delimited file with a header record, by default informatica will read all records and process it. If you want to skip the header records… Continue reading How to skip header record and read only data records in a flat file in Informatica BDM
How to get only filename from find command in Linux?
How to get only filename from find command in Linux? Normally find command will retrieve the filename and its path as one string. If you want to display only the… Continue reading How to get only filename from find command in Linux?
How to Exclude All “Permission denied” messages When Using Find Command?
How to Exclude All “Permission denied” messages When Using Find Command in UNIX/LINUX? use 2>/dev/null The 2>/dev/null at the end of the find command tells your shell to redirect the… Continue reading How to Exclude All “Permission denied” messages When Using Find Command?
How to get the script output from informatica BDM command task!
If a command task is executing a shell script, you will get the exit code, standard output and standard error from the script in the Command task output. You can… Continue reading How to get the script output from informatica BDM command task!
Informatica BDM Naming Conventions – Transformations Objects & workflows
When you use consistent names and descriptions, it is easier to understand the workings of mappings and transformation objects. When you provide a name or description, a developer does not… Continue reading Informatica BDM Naming Conventions – Transformations Objects & workflows
How to export mapping or workflow parameter file in Informatica BDM?
You can export a mapping parameter file or a workflow parameter file from the Developer tool. Define the parameters in the Developer tool and then export them to a file.… Continue reading How to export mapping or workflow parameter file in Informatica BDM?
Stop mapping when a nonfatal error occurs in Blaze Engine Informatica BDM
How to Enable Stop on Errors on the Blaze Engine when a nonfatal error occurs in Informatica BDM, use the property “Blaze.StopOnError,true”! During a mapping run, you may need to… Continue reading Stop mapping when a nonfatal error occurs in Blaze Engine Informatica BDM
How to terminate a workflow and mark the status as failed in Informatica BDM
How to terminate the workflow in case of task/mapping failure in Informatica BDM! Use Terminate Event” By default the workflow will be marked as success even-though any of the mapping… Continue reading How to terminate a workflow and mark the status as failed in Informatica BDM
Stop mapping when a nonfatal error occurs in Informatica BDM
How to stop the mapping when a nonfatal error occurs in Informatica BDM, enable function “Stop on Errors”! “Stop on Errors” stops the mapping if a nonfatal error occurs… Continue reading Stop mapping when a nonfatal error occurs in Informatica BDM
INFACMD command to export workflow parameter file in Informatica BDM
How to export workflow parameter file using INFACMD command? Use listWorkflowParams! You can export a mapping parameter file or a workflow parameter file from the Developer tool. Define the… Continue reading INFACMD command to export workflow parameter file in Informatica BDM
INFACMD command to export mapping parameter file in Informatica BDM
How to export mapping parameter file using INFACMD command? Use ListMappingParams! You can export a mapping parameter file or a workflow parameter file from the Developer tool. Define the… Continue reading INFACMD command to export mapping parameter file in Informatica BDM
Parameterizing relational tables in Informatica BDM
Parameterizing relational table object in BDM We have an Oracle relational table called “Explore_Infa_Table”. Let’s see how to parameterize the connection, table and schema name. We cannot create/define parameters in… Continue reading Parameterizing relational tables in Informatica BDM