Search found 2 matches

Go to advanced search

by sunithakona
Fri Mar 06, 2009 12:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aggregate and Join stages
Replies: 0
Views: 1102

Aggregate and Join stages

Hello, I have a few questions about Aggregate and Join stages. I'm looking to do the following, I have 2 data sources with structure below Source1 : RelID, Amt1 Source2: RelID, Amt2 I'm trying to aggregate amount fields[sum(Amt1)] by RelID in the both the datasets, then I want to left outer join the...
by sunithakona
Mon Feb 02, 2009 11:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem while loading sqlserver table using parallel extende
Replies: 4
Views: 1474

Try using the character data type in SQL Server load stage.

Go to advanced search