CODEWITHSUNDEEP
informatica
Flins
Flins

Reputation: 221

Informatica target file

I have a workflow which writes data from a table into a flatfile. It works just fine, but I want to insert a blank line inbetween each records. How can this be achieved ? Any pointer ?

Upvotes: 1

Views: 2743

Answers (2)

Sandeep
Sandeep

Reputation: 36

Here, you can create 2 target instances. One with the proper data and in other instance pass blank line. Set Merge Type as "Concurrent Merge" in session properties.

Upvotes: 1

Raghav
Raghav

Reputation: 2238

Multiple possibilities -

  1. You can prepare appropriate dataset into a relational table, and afterwards, dump data from that into a flat file. For preparation of that data set, you can insert blank rows into that relational target.

  2. Send a blank line to a separate target file (based on some business condition using a router or something similar), after that you can use merge files option (in session config) to get that data into a single file.

Upvotes: 0

Related Questions