2 Jul 2010

How to read zipfile on fly without unzipping(Informatica)

Reading source zipfile on fly without unzipping it to a physical file
When we have a source file in zip format we can read it on fly(Generating Data) and informatica reader reads the generated stream. We have few options in informatica powercenter 8.x wherein we define commands or run a script to generate or display data. Using this method we can pre-process file while reading.

Define the following under Session->Mapping Tab->Sources->File Reader
Input Type : Command
Command Type : Command Generating Data
Command : gzip -cd $PMSourceFileDir/filename.txt.zip


Posted by at

5 comments:

  1. Unknown16 September 2015 at 01:43

    Its a very good site to visit.

    http://www.tekclasses.com/informatica-online-training-best-informatica-training-in-bangalore-informatica-training/


    http://www.tekclasses.com/informatica-training-in-bangalore-informatica-training/

    ReplyDelete
  2. Unknown16 September 2015 at 01:44

    Thanks for Sharing http://www.tekclasses.com/informatica-online-training-best-informatica-training-in-bangalore-informatica-training/


    http://www.tekclasses.com/informatica-training-in-bangalore-informatica-training/Usefull information


    ReplyDelete
  3. Unknown24 September 2015 at 03:04

    Plenty of new stuff proper here!visit the below link

    http://www.tekclasses.com/

    ReplyDelete
  4. Unknown24 September 2015 at 03:11


    You have posted a trust worthy blog keep sharing.
    Regards,
    http://www.tekclasses.com/

    ReplyDelete
  5. Unknown24 September 2015 at 03:18

    Brillant piece of information,if u r interested follow below link
    http://www.tekclasses.com/

    ReplyDelete

Subscribe to: Post Comments (Atom)