DSXchange

The error message which I got was,
Fatal: ct_fetch failed or canceled during fetch to Sybase table which is the source stage

see this post..

viewtopic.php?t=127821&highlight=

before running the dsjob command dsenv should be sourced..

. ./dsenv

execute the above command and try dsjob command again..

Hello everyone,

I am getting date in yyyy-mm-dd format,before loading to target I need to add 1 month to existing date.

For ex : 2011-05-31 need to load as 2011-06-30
2010-12-21 need to load as 2011-01-21.


Could any one suggest me the approach please........


Thanks in advance

Try this..

dsjob -server <servername> -domain NONE -user xxx -password xxxx -run -jobstatus <projectname> <sequencename>

Are you able to see the data using 'view data' in dataset1 in both job1 and job2?

also in job2 try replacing oracle stage with new dataset/file(just a thought).

"NullToValue" is used in transformers and not in modify stage..

In modify stage it should be something like..

PHONE = handle_null (PHONE,-128)

See Parallel Job Developers Guide under Modify stage.

see this..

viewtopic.php?t=99257

See this post..

viewtopic.php?t=117618&highlight=

You can do that by making just one generalized job parameterizing table name as well as the filename.
Eg:

Source:SELECT * FROM #TABLENAME#
Tgt:#TABLENAME#_Timestamp.csv

the following link should help you.

viewtopic.php?t=137392&start=0&postdays ... artability

NaN stands for Not a Number...check your data ..

Hi Ray,

thanks for you reply

Following is my requirement.

Source
=====

Col
===
1
2
3
4

target
=====

Col
===
1,2,3,4


source records count will vary, it will not same always.


thanks,
Rams

it will not possible in pivot stage, we need to convert rows in to column

How to convert rows in to column in 7x Parallel

Please help me

- Rams