Handling Multiple delimiters in a informatica source file

August 20, 2012 6:05 pm4 commentsViews: 952

Ever come across a flat file source with multiple delimiters and wondered how these source files can be handled and read accurately in informatica. Multi delimiter file data essentially looks as given below; one or more delimiter candidates define the boundaries of a column as stated in my sample data.

order_no | product $ region ~ units sold ~ discount_pct | Sales_amount | discount_candidate

X1234A4 | 234543 $ IND ~ 3 $ 1@ 297 | Y


In sample data stated above, we could see four delimiters (| $ @ ~).

Let’s discuss how the situation can be handled; In tools like AbInitio, you can explicitly give the delimiter for each column through the cobol code you write.

PowerCenter is very well equipped to handle the situation, below simple steps, have a solution on board!!

Steps to follow for this solution - 

1. Open Flatfile source in Powercenter designer, double click on it.

2. Goto Advanced file properties

3. In Column Dimiter placeholder, list all the delimiters as shown in the screenshot

4. Uncheck the property “Treat multiple delimiters as AND unchecked”

Risk: If this option is checked Integration service will look for a delimiter token “$|@~”; and as we see there exist no delimiter token in the sample data which eventually endup putting all the columns under one data column; So, to avoid the mentioned risk always ensure to turnoff this property

5. Click OK to save the changes

6. Good to go now

Preview of the data will look as below =>


Leave a Reply

five − = 2

Blue Eyed Cats Pics

Scared Cat Compilation

Cute Kittens Pics

Best Vines

Talking Cats

Garcinia cambogia reviews

Wet Cats

Abyssinians Cats in Pics

Best Wins and Fails Compilation

Black and White Cats Pics

Cat Fight in Pics

Smiling Cats Pics

Cute Kittens in Pics

Auto binary signals

Funny Animal Videos

Stunts Fails Compilation

Fat Cats in Pics

Cute Kittens

Garcinia cambogia review

Green Eyed Cats Pics

Cats in Clothes Pics

viral script

Motorcycle Fails Compilation

Scary Car crashes accident compilation

Most Motivational Video Ever

cat pics

gay social networking

Muscle Maximizer Review

Funny Vine Compilation

New Vine Compilation

Collection of scary ghost videos

The Ultimate Herpes Protocol Review

Flying Cats in Pics

Google Sniper 2 Review

Funny Cats Compilation

Funny Vines

Crazy Vine Compilation

Funny & Cute Cats Compilation

Cute Cat Funny Cat Compilation

Fail Compilation

Funny Vine Compilation

Automatic Binary Options Review

Healthy diet

Amazing VINES Compilation

Funny Video

Baby Laughing Compilation

Kitty fights against sleep

Best Vines Compilation

Crazy car crashes compilation

Wins and Fails Compilation

Funny Cats Pics Part 1

Most Inspirational Video Ever

Huge Vines Compilation