Skip to content

Explore Informatica

Extract – Transform & Load

  • Home
  • PowerCenter
  • BDM
  • Unix/Linux
  • Vue Js
  • YouTube
  • Contact me

Tag: Informatica BDM

How to get the counts of deleted files in unix/linux

August 10, 2020December 11, 2020 by kvt - Comment is Closed

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 […]

Read More

How to find all writable files by a specific user in unix

August 10, 2020December 11, 2020 by kvt - Comment is Closed

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 […]

Read More

How to read comma separated data within double quotes in a csv file in Informatica BDM

August 8, 2020December 15, 2020 by kvt - Comment is Closed

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 […]

Read More

How to skip header record and read only data records in a flat file in Informatica BDM

August 7, 2020December 15, 2020 by kvt - Comment is Closed

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 […]

Read More

How to get only filename from find command in Linux?

July 29, 2020December 11, 2020 by kvt - Comment is Closed

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 […]

Read More

How to Exclude All “Permission denied” messages When Using Find Command?

July 28, 2020December 11, 2020 by kvt - Comment is Closed

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 […]

Read More

How to get the script output from informatica BDM command task!

July 27, 2020December 15, 2020 by kvt - Comment is Closed

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 […]

Read More

Informatica BDM Naming Conventions – Transformations Objects & workflows

July 26, 2020August 9, 2020 by kvt - Comment is Closed

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 […]

Read More

How to export mapping or workflow parameter file in Informatica BDM?

July 26, 2020December 15, 2020 by kvt - Comment is Closed

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. […]

Read More

Stop mapping when a nonfatal error occurs in Blaze Engine Informatica BDM

July 25, 2020August 9, 2020 by kvt - Comment is Closed

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 […]

Read More

How to terminate a workflow and mark the status as failed in Informatica BDM

July 25, 2020December 15, 2020 by kvt - Comment is Closed

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 […]

Read More

Stop mapping when a nonfatal error occurs in Informatica BDM

July 24, 2020December 10, 2020 by kvt - Comment is Closed

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 […]

Read More

INFACMD command to export workflow parameter file in Informatica BDM

July 24, 2020August 9, 2020 by kvt - Comment is Closed

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 […]

Read More

INFACMD command to export mapping parameter file in Informatica BDM

July 23, 2020August 2, 2020 by kvt - Comment is Closed

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 […]

Read More

Parameterizing relational tables in Informatica BDM

July 23, 2020January 13, 2021 by kvt - Comment is Closed

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 […]

Read More

Posts pagination

1 2

Subscribe Channel

Follow in FB

Facebook

Categories

  • IBM Mainframe (1)
  • Informatica (186)
    • ETL Jobs in USA (70)
    • Informatica – Whats New? (2)
    • Informatica BDM (21)
    • Informatica Cloud (4)
    • Informatica PowerCenter (52)
    • Informatica Trainings (6)
    • Performance Tuning (3)
    • PowerCenter Certification (20)
    • PowerCenter Installation (2)
    • PowerCenter Interview Questions (1)
    • Shell Scripting (8)
    • Troubleshoot (5)
    • YouTube Videos (6)
  • Vue Js (5)

Recent Posts

  • How to Sign up Microsoft Power Apps without business or work email
  • How to extract middle name in Informatica Power center
  • How to extract first & last name in Informatica Power center
  • Build a real time web application using Vue.js, MySql, Php, Firebase and Google cloud
  • How to calculate Age in informatica power center

Tags

Advanced Workflow Aggregator BDM Automation Certification Developer Tools ETL Jobs Expression Filter Transformation Flat FIles Full Outer Join Functions Informatica Informatica BDM Informatica Certification Informatica Cloud Informatica Jobs Informatica trainings Informatica Webinar Installation jobs Joiner Lookup Mapping Normal Join Oracle Connections Performance Tuning powerCenter PowerCenter Certification PowerCenter Express Rank Repositories Sequence Generator Sessions Sorter Transformations Source Qualifier Target Connections Transformations Transformations-Lab Troubleshoot Unix Shell Scripting in BDM Update Strategy Transformation Vue js workflow Workflow Manager Working Tips
© Explore Informatica
Go to mobile version