DSXchange

That looks like a better idea. That can be handled separately in the initial pace and send a notification to users.

Yes, I too thought of a similar fashion. Thought would have a reference_file.csv and compare the two data files - file1.csv and file2.csv. Change the files into the format of reference_file.csv and proceed with our jobs. But in case of one column not coming in the input file, i.e., parts_name is not...

Hi, The scenario is like this file1.csv Customer_id,customer_name,parts_name,vehicle_name,parts_no file2.csv Customer_id,customer_name,vehicle_name,parts_no Here in both the files, parts_no is the key field. Two files come from external systems. Both the files are dynamic and columns can be swapped ...

Hi,

The requirement is as

1 ABC
2 CBE
3 DEF


The records each should go into file named ABC.txt, CBE.txt, DEF.txt.

ABC.txt
1 ABC

CBE.txt
2 CBE

DEF.txt
3 DEF


Is there a way to get this way? Please help

There were special characters parameterized in the job. They were given in single quotes in the stage variables.when they were changed to double quotes, it worked.

Thanks.

Hi Prem,

The parameter used in the job do exists in the parameter set. Is there a possibility of some other error?

Thanks.

Hi,

Getting this error

main_program: Data set, file set, or file "Trim_Data:TrimmedData.v": Non-pipe (or non-virtual data set) with .v in its name

The source is a fixed width file. The output is a pipe delimited file. There is a transformer which trims the spaces. Please help.

Thanks.

Actually there is 116 GB space free on the server and I have 7 million records to be change captured. Is there any way to increase the scratch space? Or I need still more space on the server.

Hi, I am getting the same problem again and again when I run my job. It has two sequential files and a change capture. It runs in ten nodes. It ran fine during development. Please help me in resolving this issue. Is this a space constraint in server. buffer(0),0: APT_BufferOperator: Add block to que...

Hi, I get a warning "Sequential_File_59,0: Input buffer overrun at field "CUSTOMER_NAME", at offset: 4 [impexp\group_comp.C:5767]" This is because there are spaces from a fixed width file input.These spaces are not getting trimmed even if all the string functions are applied in t...

Here Remove_DUPS is the remove duplicate stage name

Remove_DUPS: When checking operator: User inserted sort "Sort" does not fulfill the sort requirements of the downstream operator "Remove_DUPS"

Hi,

I got this warning in my remove duplicate stage.

When checking operator: User inserted sort "Sort" does not fulfill the sort requirements of the downstream operator.

Please help me to fix this issue.

I have already tried by giving the partitioning as Entire for the three lookups which are giving the same warning,but the same warning continues.

The Lookup stage is generating the error.
The input is a sequential file.I have a transformer before my Lookup.

Hi,

I get this warning with three of my lookups

Input Dataset 0 has partitioning other than Entire specified; disabling memory sharing.

Previous posts could not help it out.
Even when I changed the partitioning to Entire I got the same warning again.How can I solve this issue?