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… Continue reading How to get the counts of deleted files in unix/linux
Author: kvt
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}… Continue reading How to find all writable files by a specific user in unix
Pushdown optimization in informatica PowerCenter
This article will help you to understand Pushdown Optimization technique to enhance Informatica ETL performance. We will see how to implement Pushdown optimization and its limitation. Author: Dhandhaliya Dhiraj Informatica ETL Developer | SQL Developer | IICS Developer | IDQ Developer Email | Linkedin Profile What is Pushdown Optimization? Pushdown Optimization is use to increase… Continue reading Pushdown optimization in informatica PowerCenter
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 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… 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 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… Continue reading How to skip header record and read only data records in a flat file in Informatica BDM
05 Transformation language: Tips for Informatica PowerCenter Specialist Certification!
There will be 6 questions from this topic. There is one entire pdf document is talking about this topic. You can download the document from the below url. This describes how you can use constants, operators, variables, dates, and functions to transform source data. Transformation Language What to study & Where to focus Even-though its… Continue reading 05 Transformation language: Tips for Informatica PowerCenter Specialist Certification!
FREE onDemand training on Informatica Cloud B2B Gateway: Foundations
Want to master in Informatica Cloud B2B?? Informatica is providing FREE training in Informatica Cloud B2B Gateway Foundation level. It’s an on-demand course which will cover Informatica Cloud B2B Gateway for electronic data interchange (EDI) processes. Master the onboarding of a partner, set up the inbound and outbound flow for the partners, set up a… Continue reading FREE onDemand training on Informatica Cloud B2B Gateway: Foundations
04 Parameters & variables: Tips for Informatica PowerCenter Specialist Certification!
There will be 6 questions from this topic. You can go through the below sections in the Informatica PDF document to learn about Parameters & variables. Designer Guide Chapter 7: Mapping Parameters andVariables Advanced Workflow Guide Chapter 15: Parameters and Variables inSessions Chapter 16: Parameter Files What to study & Where to focus Mapping Parameter… Continue reading 04 Parameters & variables: Tips for Informatica PowerCenter Specialist Certification!
03 Sample Questions! Informatica PowerCenter Specialist Certification.
Informatica PowerCenter Data Integration 10: Developer, Specialist Certification. This is the third video in the tutorial series. This will give you some idea about the sample questions. Please do like and subscribe the channel for more videos. Liked the content?? Please Like FB page & subscribe the channel! Let’s learn together!
02 Exam topics! Informatica PowerCenter Specialist Certification.
You can find all the required Informatica PDF documentation in the links below! Informatica Documentation center Getting started: Transformation Guide: Designer Guide: Transformation Language Reference Workflow Basics Guide: Informatica PowerCenter Data Integration 10: Developer, Specialist Certification. This is the second video in the tutorial series. This will give you clear idea about the test topics,… Continue reading 02 Exam topics! Informatica PowerCenter Specialist Certification.
01 Things to know! Informatica PowerCenter Specialist Certification!
Informatica PowerCenter Data Integration 10: Developer, Specialist Certification. This video will give you some basic informations about this certification exam. This is the first video in the tutorial series. Please do like and subscribe the channel for more videos. Liked the content?? Please Like FB page & subscribe the channel! Let’s learn together!
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 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… 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 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… 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 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… Continue reading How to get the script output from informatica BDM command task!