informatica-powercenterinformatica
Error while reading source file name starts with a number in informatica
The source file name in my project starts with a number for example 20070908abcd.csv. Informatica is not allowing to read the source in the designer and displays the following message:
The first character in this name cannot be a number.
Could you please let me know how to handle as many source files are of this format?
Solution
The name of a source file can start with a digit and it will be processed correctly. However, the first character in the name of a source transformation cannot be a number.
When importing a file, enter a correct name (by default, file name is used) for the new source that will be created:
- Which one is better performance wise in Informatica Powercenter? Use sorter transformation or add number of sorted ports on source qualifier?
- Using a Command Task to create a shell to run the same workflow again in a loop using nohup
- Using REG_MATCH and REPLACESTR function in Informatica to replace a suffix character
- Pick the latest file based on datestamp provided in the filename
- Date Formats comparison in Informatica
- Instr to find the exact pattern match in informatica
- Informatica new line and carriage return
- How to check the used space during run of an Informatica Powercenter Workflow?
- Running a .bat script in IICS informatica using Command task
- How to pass sql script result value to variable in Informatica PowerCenter
- Create a file list in IICS informatica and load the files to a table
- How to compare string with Latin characters to same string with English characters in IICS?
- How to create repeted seq in informatica?
- Cannot connect Informatica to the Oracle DB on Docker
- How to write regex or any replace function to replace with null where [,-] pattern exist
- How to load Multiple excel source files with different structure into a target table in Informatica
- INFORMATICA POWERCENTER: Mapping issue and XML output
- Find the folder name and mapping name details impacted by particular target table in informatica
- Compare the count of two tables in informatica
- Create the Mapping and Display Runs For Each Over and I Also Add First Over Runs in the Sum of Second Over Runs and Same for Third Over
- I want to Assign 'Y' to the Duplicate Records and 'N' to the Unque Records, And Display those 'Y' and 'N' Flags in 'Duplicate' Column
- Convert Below Source File in Notepad++ and also in Informatica. See the Given Source Table and Output Table I Want
- How to generate flatfile with zero records when there are no records in source?
- Informatica Powercenter Repository location inside the physical machine
- How to stop a workflow immediately when a session fails?
- Split String into multiple columns in Informatica powercenter
- What does retain persistent mapping variable value mean in informatica when importing a mapping(XML file) in the repository
- How to Pass Workflow Variable to Worklet
- Informatica PowerCenter Greenplum Connector
- How to perform loop in informatica power center?