on 02-08-2010 1:28 PM
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
>
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.