DSXchange

We usually ftp the Mainframe Dataset into the UNIX box using FTP stage and then convert to ascii and do further processing.

Hi Shiva,

What value do you have in the SMTP Mail Server Name?.

Hi Craig,

Your solution is good. I was thinking along the same lines. However, I wanted to know the various options that I have, to tackle this problem, before choosing a method. Thank you very much for your input.

Hi Guys, My Input file is of the below format ColA ColB 10 100 10 101 10 102 10 103 22 910 22 911 22 912 Each Value in ColA has mutliple different values for ColB My Lookup file is of the below format ColA ColC 10 2 22 1 The requirement for my job is that I need to match the input file records based...

Hi NaveenD, Yes, your earlier statement was misleading. However, I do agree with what you mean by it now. I have already asked her to check the same thing in my first response Also, check the format of the sequential file you are trying to read from and depending upon the format, use the appropriate...

Hi NaveenD, the problem here is the input file format is different from the target file format I dont think that's true. The Input file format can be different from the Target file format. We have tons of jobs where we take the input as .csv file and create the ouput file in the fixed width format.

Hi Anu,

Adding few columns in the transformer and then propogating them to the target is absolutely fine. It should not give you any error.

After adding those new columns, did you compile and run the job, before trying to do view data in the target.

Hi Anu, Seems like your metadata is not matching the data that you are trying to read from the sequential file. Check to make sure the column names,sizes,position,type exactly match the data that you are trying to read. Also, check the format of the sequential file you are trying to read from and de...

Thanks Sai for the clarification.

Hi Guys, When we get the OLE error and we try to close the currently open job. It asks whether it needs to save the changes or not. I have been told to always say "No" to this, as they believe that it will corupt the current job, if we say "Yes". Is it true or Is it one of those ...

Hi Anu, If I understand your question correct. When your lookup field value (Input2) is not found in your input (Input1). You want to populate a target field with "N" To achieve this you can use the link variable "INPUT2.NOTFOUND" and use this as a condition to populate your targ...

Hi Anu,

Like Sainath told in one of the previous posts "CRC32 is a 32 bit fn and CheckSum is a 16 bit fn".

So you are better of using CRC32 than CheckSum as the former has more probability of returning different checksum values for two different input columns.

Hi Ray,

Thanks for the usefull information. Like always "Ray is the Best". :D

Thanks,
Naveen

Hi Sumit,

I believe that Remove Duplicate Stage is present only in the PX version (EE version) but not in the server edition. Guys, please correct me if I am wrong.

Thanks,
Naveen

Hi Guys,

Can't we break the input date DD-MM-YYYY into three subparts i.e DD,MM,YYYY and then combine them together in the required order YYYY-MM-DD?

Thanks,
Naveen