user1173496
user1173496

Reputation: 111

Need to convert data into Dat files via Informatica

I am new to Informatica so need your help.

I have one staging table where data comes everyday and I need to extract data from this staging table and convert it into Dat file format and place in into a folder. so that these dat files could be a feed for another process.

I dont know how informatica does this (Conversion of data from Staging table to Dat). So please help me to know how Informatica fetch the data from staging table, transform it into Dat file and place it into a folder.

Thanks & Regards, Vikram

Upvotes: 2

Views: 3699

Answers (2)

bob
bob

Reputation: 390

To create a pipe-delimited flat file...

Go to the Target Designer - Select Target->Create then choose Flat File. Then double click on the file, and in the 'Table' tab, at the bottom right select 'Advanced' and choose your delimiter. Then you can add your columns, specify the file location and all is well!

Upvotes: 3

Rajesh Chamarthi
Rajesh Chamarthi

Reputation: 18818

You will need to define a source definition based on your staging table, a target definition based on your final file format and then create the mapping,session and workflow that link the two.

.Dat file is not a complete description for the file, since any file can be renamed to a .dat file. You'll need to decide how the data would be separated in this file (commas? tabs? pipes?). Remember all downstream processes will then use this file as input, so you need to publish this format too.

Upvotes: 1

Related Questions