DSXchange

I would examine the reject records first and then try to get a clue from the director log.

What does the director log say about the two reject records? any warnings or error messages?

I googled your sqlcode.

-1438: value larger than specified precision allows for this column.

Does that ring a bell?

You might want to use a Look up stage like ArndW said, choose either link as a Master, Store the output of both the links, and concatenate them on their way to the target table/file. Does that make sense?

Try Re-indexing.
on your Datastage Administrator.

HTH.

ray.wurlod wrote:The fastname must be a genuine node name, ideally the one on the fastest connection to that machine. Do you really have a node called "a"? ...

By node name do you mean server name?

If you're trying to convert a varchar to decimal in Modify stage you need to use the following function:

decimal_from_string

decimal_col:decimal = decimal_from_string [ceil] (source_col)

For more information on this function you can refer Parallel job developer guide.

Hope that Helps.

-Hiral

Dear All, I have two empty master detail tables say journey (journeyid is PK) AND Trucks(Truckid is pk,journeyid if FK) i have loaded master table records and i need to load second table Trucks where i need to populate journeyid values from Journey table. as Trucks is an emptty table ,i dont have a...

juancho wrote:Hello!

Is there a way to convert, using modify stage, a string field with the following data:

12034

to decimal 5,2? that is, to 120,34

So you mean you would like to convert 12034 which is a varchar to 120.34 which is a decimal(5,2) ?

-Hiral

You need to use a date dimension that has a "month_number" that starts at 1 for the first month on your date dimension and goes like this : Lets say your date dimension starts at January 01, 1980. Date Month_Number 1980-01-01 1 .... .... 1980-12-01 12 1981-01-01 13 .... .... 1981-12-01 24 ...

I am using version 8.1.0, and I'm facing the same problem.

Does anybody know of a patch for this?

Thank you micheald !

~Hiral

[quote="Minhajuddin"]You get this warning whenever you use a sort stage to sort on different keys before a join, aggregator or a remove duplicates stage.

Thanks Minhajuddin !

Hi Experts, I have requirement like For eg: In.col1=01-01-2007 in.col2=01-03-2009 i have to take how many months are there in output between two above dates. Please let me know how to achieve these. Thanks in Advance There is no direct way to get the number of months. But here's an indirect way: Da...

chulett wrote:Maybe so, but this is a discussion in the Server Edition forum on how to do this in a Server job, not a Parallel job. ...

My bad ! now I see why I did not find this topic anywhere else..

Probably most people know this by now, but there's an easier way to subtract dates in transformer (not BASIC transformer.. the one in 8.1.0) DaysSinceFromDate(CurrentDate(),DSLink21.PROD_DT) Result = 26 In my example CurrentDate() is 3/26/2009 and DSLink21.PROD_DT = 2/28/2009 (There was actually a f...

Maveric wrote:Write the data into the file as Varchar. Convert the data type in a transformer to using DecimalToString() function with suppress_zeros option.

Thanks Maveric!

Your tip did the trick for me!!

-Hiral