DSXchange

Oops Right Ray. But I hope u got my problem. Concerns for your soln. Rasi is that : 1) Putting 2 queries on Source side will loads the Source because of which I don't have the Liberty i.e why I have a SplitTrans (Transformer) to do Splitting. 2) Also in the Solution HASH1 and HASH2 are two different...

Is there any issues that need too be considered while using the Collector Stage in Datastage Server Jobs????? I need to do a following thing in Server Job Problem : If a value for a Particular Column is A. then i need to do a lookup with a hash file. If it is not found or if the say COLUMN <> A, the...

Thanks for the response.

The data is already coming in yyyy-mm-dd hh:MI:ss.s(6) format from the I/P . So do we need to still use tha Format syntax as you had Given ?

Though I changed it and run I got the same problem. What else do you think should I be looking at the teradata end.

I am trying to load a flat file into the Teradata using MLOAD Plugin . I am getting the following error 5407: Invalid operation on an ANSI Datetime, in the Log file(report file ). The i/p has 4 cols out of which 3 are key cols and out of these key columns 1 is a timestamp(6) format in teradata.While...

Right, I think I should have Posted with a comment saying suggestion

Think that Sequence Id is better if created at the DataBase level...
Need to be careful if there is any sort of migration , as these conditions are easily handled at the RDBMS level

Hope u are using the Sequencers for batch , there is a Routine Activity stage to call a DS routine.

Hi, I noticed a strange thing , let me know if anybody has faced a similar problem. Inside the transformer I have used in the Derivation for two columns as @NULL , the O/P is going to a sequential file . What has happened is where the metadata for the column was Decimal(3,2) , the Data in sequential...

Did you get any response from Ascential about it. I am on DS v6.0.1 and I am also getting the same error.

Does this set of files have same Metadata.Then you can go for a two step job like in the first job using folder stage u get the filenames , and then use this as an parameter to call the Second job where you would be Accessing the file and extracting releveant columns and putting into the table

Yes, I have also seen this functionality.But my guess is not inserting the record(6.0 Feature) is better than the truncating and inserting feature(4.x). Which in 4.x u needed to check the data length before inserting the data as otherwise the truncated data used to get loaded. Not sure if we can set...

Hi,

You can check the field function to do the functinality , to get the different values for the Column.

Hi all, Thanks for the First one "Patch" , Ds is not aborting.Is it some bug. Yes, For the Second one I also don't know some problems in Excel.When i create the excel file it is OK...I think the problem is only in the way that Excel file was created by them or some other bug at Excel level...

Hi, 1) I have a fixed width file , that has got a column name in FirstLine. The EOR for the First Row i.e. i think the last column name is occuring a bit earlier.So DS job is getting aboted. Does that mean that even though the first line is the Column name it still has to follow the metadata. 2) One...

Also in integrity, there is something called as Pre-built Procedures and just procedures which are created using the set of operators.What is the Difference? I noticed one more thing if we use the superStan then we need to use the rule sets. Where would i use just the procedures and where will i use...