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 -l. To delete a file rm -f source_fname_*.txt To get the counts of deleted files rm -vf source_fname_*.txt | wc -l To find & delete […]
Read MoreTag: 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 writable find . -writable To find all writable files in a specific directory that are writable by the specific user: find {file_path} -writable -user {user_id} […]
Read MoreHow 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 BDM, that particular data field looks truncated since the comma within data will be treated like a delimiter. To fix the Issue you need to […]
Read MoreHow 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 and read only data records, give the “start import at line” value as “No of header records”. In the below example since I have only […]
Read MoreHow 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 filename, you can use basename command. find {file_path} -type f -iname {file_pattern} -exec basename {} ; find infa/bdm/server/source/path -type f -iname “source_fname_*.txt” -exec basename {} ; Search tags! How do I […]
Read MoreHow 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 standard error messages to /dev/null, so you won’t see them on screen. “/dev/null” is a virtual device file, Whatever you write to “/dev/null” will be […]
Read MoreHow 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 assign these fields to a workflow variable in the “Command Task Output” and use later in the workflow. Let’s consider a shell script which will […]
Read MoreInformatica 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 have to spend time going through an object or mapping to understand its objective. Informatica is suggesting us to use some guidelines while developing […]
Read MoreHow 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. The Developer tool creates a parameter file in .XML format. You can export a parameter file that contains mapping parameters or workflow parameters. You can […]
Read MoreStop 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 interrupt the entire mapping after the Data Integration Service encounters an error or exception. To do this, enable Stop on Errors on the Blaze engine in […]
Read MoreHow 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 or tasks failed. You can use the “terminate event” to force a workflow to fail in case of any mapping or task failed. Add an […]
Read MoreStop 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 in the reader, writer, or transformation threads. There is no threshold to set along with this property, As soon as the mapping encounter any reader/writer/transformation […]
Read MoreINFACMD 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 parameters in the Developer tool and then export them to a file. The Developer tool creates a parameter file in .XML format. You can export […]
Read MoreINFACMD 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 parameters in the Developer tool and then export them to a file. The Developer tool creates a parameter file in .XML format. You can export […]
Read MoreParameterizing 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 the object level. This should be done in mapping level and then link with the run time fields in the object. Go to Advanced property […]
Read More