unix for informatica

**sushil010** · 03-25-2015, 05:51 PM

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

**vijay** · 03-26-2015, 05:23 AM

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

**sushil010** · 04-01-2015, 02:33 PM

Originally Posted by vijay

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 ....