Publish to pipe delimited flat file(|) is possible with CA Data Maker (TDM tool)? If yes please help me with the steps? Appreciate your help.
Did you look here?
Mask Data in Fixed-Width or Delimited Files
Fast Data Masker lets you mask the data in fixed-width and delimited files. The delimited file type includes character-, comma-, and tab-separated files.
Fast Data Masker expects these file types to follow a specific format. If a file does not adhere to the required format, Fast Data Masker cannot process it for masking.
An example of a delimited file that contains the sample data is as follows. This file is a character-separated file, which includes the pipe character (|) as a separator. This file includes three rows of data.
1|James|Lynn|39 2|John|Smith|50 3|Mary|Jane|30
This data file follows the structure that is defined in the associated definition file. An example of a definition file that is related to the delimited data file is as follows. The first row of the definition file gives general details about the file. The DELIM parameter in the definition file defines that the pipe character (|) is used as a separator in the data file. The file also defines the column names: ID, FIRSTNAME, LASTNAME, and AGE, which correspond to the data included in the data file. For example, the first row in the data file is related to the data definition file as ID=1, FIRSTNAME=James, LASTNAME=Lynn, AGE=39. Other rows also follow the same representation. The definition file does not define any header and trailer values.
HEADER=N,TRAILER=N,DELIM=|,DATEQUOTED=,CHARQUOTED=,NUMQUOTED= ID FIRSTNAME LASTNAME AGE
The following list includes information about the parameter names, description, and values used in the first row:
I have pointed you to FDM as that maybe your only option.
Thanks Les for the reply. This is helpful from the Masking front. But I am specifically looking GT Data Maker Solution for Flat File Generation (Publish to pipe delimited Flat File). I couldn't find any options in Data Maker to publish the result to a pipe delimited flat file.
For a pipe delimited file, you can create a definition file with the parameters mentioned below on line 1 followed by the column names.
Then you can register this template in Datamaker through the option "Delimited File from G-T text file". Data can be imported to the data pool by right clicking the same and selecting the "Import External File Data". Finally select the "Publish to file (FD)" option to get the corresponding output.
I have attachéd the sample template you can use.
This is helpful. I am trying to publish from an Excel to Flat File and the out put FF should be pipe delimited. Is there a way you can think of for this ?
You can publish to a csv and then maybe have a poist publish action to replace the delimiter from comma to pipe.
If you always require pipe as the delimiter, then you can change the system settings though control panel to set the "List Separator" as pipe instead of comma which is the default. This will get reflected in all applications as well. eg: if you save a csv from excel the separator will be pipe once you make this change.
Thanks Anil. This really helps..
The same concept that allows the masking should allow generation of pipe delimited files. When you register an object, one of the options is to register it as a GTExcel file. This is a file that defines the filed layout of the flat file. It allows for a header and footer and multiple record types. I couldn't find the details of this in the documentation so I will try to locate my template file and upload it here with a more detailed explanation. Maybe someone else in the community has a template that they could share. I know this is possible. The one thing I am not sure about is whether or not this can be accomplished with variable width fields. I'll look into that and get back to you.
Retrieving data ...