DSXchange

Could any one explain the differece between disk pool and scrach disk in data stage in configuration file

Whats your source and tareget? As mentioned, Use sort stage or order by clause with both the the fields. Not sure, if your question is about partiton. ... Thanks for your help, below one is the process, 1. Extract the data from ODBC 2.Use the Transformer for business logic (concatenate two names) o...

Hi Friends,
Can any one help to me, how to get the data in sequence, below example will show the structure and give the idea.

EX:

1 000021158710
1 000021158720
1 000021158730
2 000021191310
2 000021191320
2 000021191330
3 000021191410
3 000021191420
3 000021191430

Hi Friends, When I am extracting data, job has been failure. I checked OPJAGA Column has Nvarchar(6) but its giving problem, Can any one tell what the exact problem Failure: ODB_TABLE: [IIS-CONN-DAAPI-000399] Schema reconciliation detected a size mismatch for column OPJAGA. When reading database col...

Hi Friends,

Please can tell any one meaning of this message


WARNING:::: Invalid character(s) ([xFC]) found converting string (code point(s): N[xFC]rtingen) from codepage UTF-8 to Unicode, substituting.

The DateFromDaysSince function is what you are looking, described on page 593 of the Parallel Job Developer Guide ... Thanks for your reply, This DateFromDaysSince is not correct for my logic, actually I want If my date is 20100225 from that I have to minus the 6 moths so the result is 20090825, Pl...

Hi friends,

Can any one help me how to susbtract month from YYYYMMDD. Please look a exaple below.

next order date CCNPOD = 20100225
interval CCMPMO = 6
result should be : 20090825

CCMPMO ---Decimal (2)
CCNPOD ---Decimal( 8 )

Hi friends,

How to compare the Date,Here the input Data type is Decimal and i need to compare the current date with the input decimal value, Please help me in this one.

CCVADF and CCVADT are the DECIMAL (8)

ccvadf<=TODAY and ccvadt>=TODAY

Hi Friends,

Can gclarify below warning why its coming and how to solve


ODB_WORK_NOTIFICATION_LL: Schema field VBBANO in input data set 0 not present in design time information. Extended field properties for this field will not be available.

Hi friends,

Can any one help to me how to implent the rank for a 1000 members in a class from 1 to 1000

If two students get same marks based on Maths marks we have to decide which student rank is higher than second one.

Hi Friends When I have generating the values from DECIMAL TO STRING Its not giving the exact rsults Can some one help me. condition: DecimaltoString(column name) results :: 09400077. 09400259. 09400417. 09400634. at the end giving dot( . ) I dont need that dot and moreover the decimal size is 8 and ...

Hi friends,

Can any one help me how to solve below like condition logic in datastage

if okmodl+ okexcd+oktedl contains 'FOB' then 'Y00' else 'y01'--> For this we need "FOB" word either its FOB or ENFOB or LLELFOBND, Just among this FOB word we need

Assuming you mean in a parallel transformer: If Left(InLink.okcucl,1) = '5' Then '020' Else If Left(InLink.okcucl, 2) = '65' Then '030' Else '001' Hi, When I tried this logic, not given sufficient result It's giving wrong I need below kind of data, Please send proper logic 5612 ------020612 6589 --...

Hi Friends

I have one if else logic, can share with me how to implement below condition in data stage.


if 1st character of okcucl = 5 then 020
else two first character of okcucl = 65 then 030 else 001

Hi Friends

I am getting below warning Can any one help to solve warning


LOOK_MITBAL,0: Ignoring duplicate entry at table record 834; no further warnings will be issued for this table