DSXchange

We have certain jobs that use Oracle connector. I just want to understand if the it can handle the following: - Table being loaded ran out of extents or the tablespace ran out of room? - Network disconnect, database outage, or other issue that prevents data from being loaded? The question is whether...

I have a lookup table which has a structure like this: Ref_File Master_File ---------- ------------- a.txt Ref_a.txt b.txt Ref_b.txt c.txt Ref_c.txt hen I lookup onthe table a.txt, the output is Ref_a.txt. I want to use this value as a parameter and pass it to a seq file stage which will fetch the d...

If at any point the validation fails, then we just get notified by email. We will take it up to the source people

We have a lot of jobs that load data from flat file to an oracle table. Each src file also has a control file that contain a count of the records. After the data is loaded to the table, I need to validate if the control file count and records that are loaded is same. I know this is a pretty common s...

I have a column (loast column) coming from a flat file (fixed width). I am doing an integer validation for it using the below statement: If IsValid("int32", Col) then 'Valid' else 'invalid' The values in the source file are between 0 to 5. I was expecting the output to be 'Valid'. But surp...

Awesome. Thank you Ray/Eric. This saves a lot of time.

There are lot of source files which are fixed width and I am using 'CHAR' to read them and it works well. It also turns out that I get spaces in certain columns because of this. There are more than 80 files and each file has 200+ columns. Is there any way to handle these other than using a Trim in t...

All the values are set to 0.000.

I have a oracle target table column with data type as Decimal and its precision is 12,3. SO, it can accomodate 3 digits after the decimal. I have an input coming from a flat file with the following values : 100 200.1 300.123 10A IsValid("decimal[12,3]", SrcCol) then SrcCol else SetNull() I...

I need to build a simple routine to handle a logic like this. I went thru the option of creating a enw parallel routine. But, I am lost as to where I need to put this logic. There doesnt seem to be a place to add this code. If IsValid('date', ToTfm.AS_OF_DATE,"%yyyy%mm%dd") then StringTODa...

Thank you. I will pass the date as a parameter and handle this.

Thank you for all your inputs. So, I guess I will have to manage this cumbersome process. I will at least try to develop a routine to reduce the lengthy if-then-else statements

I am creatting a file that is captuting BAD records on a daily basis. I need to name is as FileName_YYMMDD. I cannot use the After_Job routine because that is used for creating the Log file usign the DSJobReport. I used the built in marco like this FileName_#DSJobStartDate#. But thatis creationg it ...

But, I still need to call thsi routine in the derivtion in the Tfm stage right? Hope I am not missign anything here.

I have a job that loads data from a SEQ file to Ora table. While loading I need to check the following conditions for Date and Number columns: 1. If its a valid date, then insert the value else set it to NULL 2. If its a valid number, then insert the value else set it to NULL. Implementing them is n...