Results 1 to 3 of 3

Thread: unix for informatica

  1. #1
    Junior Member
    Join Date
    Oct 2012
    Posts
    14
    Blog Entries
    1

    unix for informatica

    hi

    every one

    i need some help to solve my issue

    my source is coming daily basis. my requirement is create one external file based on source structure
    as
    src
    id,name,add

    then my external file should contain
    filename fieldname position
    src id 1
    src name 2
    src add 3

    after this ,this external file is used in my mapping .

    i'm unable to create this file through unix scipt.

    any suggestion is apriciated

  2. #2
    Senior Member vijay's Avatar
    Join Date
    May 2012
    Location
    Hyderabad
    Posts
    515
    This can be achieved with awk command.

    Code:
    awk -F',' 'BEGIN {output_file="output.dat"} {print "src id "$1 > output_file; print "src name " $2 > output_file ; print "src add "$3 >  output_file}' source_file

  3. #3
    Junior Member
    Join Date
    Oct 2012
    Posts
    14
    Blog Entries
    1
    Quote Originally Posted by vijay View Post
    This can be achieved with awk command.

    Code:
    awk -F',' 'BEGIN {output_file="output.dat"} {print "src id "$1 > output_file; print "src name " $2 > output_file ; print "src add "$3 >  output_file}' source_file


    hi
    vijay
    thx 4 ur quick responce

    is there any way that we can store this filname and column name in any variable and use that variable ,instead of using hard coded as src id ....

Similar Threads

  1. Unix command in informatica
    By Lenin in forum ETL tool basics
    Replies: 0
    Last Post: 03-13-2015, 09:00 AM
  2. Replies: 0
    Last Post: 05-09-2014, 09:30 AM
  3. unix - file location identification in informatica
    By alex in forum Unix and Linux basics
    Replies: 0
    Last Post: 01-15-2014, 08:40 PM
  4. unix - Unix shell script to automate Informatica loading
    By alex in forum Unix and Linux basics
    Replies: 0
    Last Post: 12-18-2013, 05:30 AM
  5. unix - Update informatica session properties using unix
    By alex in forum Unix and Linux basics
    Replies: 0
    Last Post: 10-21-2013, 08:30 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •