cancel
Showing results for 
Search instead for 
Did you mean: 

O/bnd Proxy to File scenario

Former Member
0 Kudos

Hi Experts

My questions are around a file to Proxy Scenario

The outbound file to be created is of the following format

#, Constant A,Constant B,Constant C,Names of the groups for the date mmddyyyy <---- Header line

Field1,Filed2,Field3, , Constant1,Field4,Constant2, ,Field5

Field1,Filed2,Field3, , Constant1,Field4,Constant2, ,Field5

Field1,Filed2,Field3, , Constant1,Field4,Constant2, ,Field5

...and so on

I have the following questions -

a) How do I create my structure for the File? Do I have to create the Header and Line Item seperately in the Data Type .Since Header in this case consists of a # then constant A B and C all comma seperated , so will it be like this

DT_File

Structure

Header

ConstantA

Constant B

Constant C

Constant D

Lineitem

Field1

Field2

Field3

Blank1

Constan1

Or can these blanks and Header text can be taken care in the File Content conversion ??

b) or should the structure be like this

DT_File

Header

ConstantA

Constant B

Constant C

Constant D

Lineitem

Field1

Field2

Field3

Blank1

Constant1

c) there are certain fields like the date in Header in the format mmddyyyy which will come in the mapping , how can this be shown in the output file ?

#, Constant A,Constant B,Constant C,names of the groups for the date mmddyyyy

thanks

Dev

Accepted Solutions (0)

Answers (1)

Answers (1)

Shabarish_Nair
Active Contributor
0 Kudos

>

> Hi Experts

>

> My questions are around a file to Proxy Scenario

> The outbound file to be created is of the following format

>

> #, Constant A,Constant B,Constant C,Names of the groups for the date mmddyyyy <---- Header line

> Field1,Filed2,Field3, , Constant1,Field4,Constant2, ,Field5

> Field1,Filed2,Field3, , Constant1,Field4,Constant2, ,Field5

> Field1,Filed2,Field3, , Constant1,Field4,Constant2, ,Field5

>

> ...and so on

>

> I have the following questions -

>

> a) How do I create my structure for the File? Do I have to create the Header and Line Item seperately in the Data Type .Since Header in this case consists of a # then constant A B and C all comma seperated , so will it be like this

>

> DT_File

> Structure

> Header

> ConstantA

> Constant B

> Constant C

> Constant D

> Lineitem

> Field1

> Field2

> Field3

> Blank1

> Constan1

>

> Or can these blanks and Header text can be taken care in the File Content conversion ??

>

> b) or should the structure be like this

>

>

> DT_File

> Header

> ConstantA

> Constant B

> Constant C

> Constant D

> Lineitem

> Field1

> Field2

> Field3

> Blank1

> Constant1

>

/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts

it will help you design your structure. Note that balnks etc has to be handled as part of the mapping. you cannot add blanks in FCC

> c) there are certain fields like the date in Header in the format mmddyyyy which will come in the mapping , how can this be shown in the output file ?

>

> #, Constant A,Constant B,Constant C,names of the groups for the date mmddyyyy

>

>

> thanks

> Dev

as part of FCC, the formats will be retained. So you dont have to worry