DSXchange

miwinter wrote:How does your data look? What format/delimiter options have you set?

yes delimiter is correct,thats why i am able to view the data.

Hi, I am extracting data from sequetial file and trying to loading into a db2. My job design is like this:- seq file stage ----->transformer stage------->db2 udb stage view data is working fine but while running the job gets aborted with fatal error Sequential_File_0,0: Error reading on import. Sequ...

Hi, I am getting fllowing compilation error in the transformer stage:- Output from transformer compilation follows: ##I TFCN 000001 12:55:04(000) <main_program> IBM DataStage(tm) Parallel Extender 7.5.3 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I TUTL 000031...

use a sort stage, sort on MISDN and DATE ASC. remove duplicate on MISDN and keep the first record. Yes i am doing the same thing but target data is mismatching,due to multiple nodes :oops: When i am running on single node,it works fine. So is there any way so that if i run the job on multiple node,...

Hi , I have source data sample as msisdn,date 750500337,6/4/2009 750500337 ,6/5/2009 750500337 ,6/6/2009 750500337 ,6/7/2009 750500467,6/4/2009 750500467 ,6/5/2009 750500467,6/6/2009 750500467 ,6/7/2009 and i want output as 750500337,6/4/2009 750500467,6/4/2009 i.e. minimum of date in each msisdn gr...

You cannot view the log files directly. You can use the "dsjob" command with options such as "-logdetail" or "-logsum" to extract log information. Logs are purged manually or by using autopurge settin ... When i am running this coomand on AIX box, i am getting followin...

You cannot view the log files directly. You can use the "dsjob" command with options such as "-logdetail" or "-logsum" to extract log information. Logs are purged manually or by using autopurge settin ... Thanks a lot for your quick reply. Can i save this log into flat...

Hi,
Can we see the datastage log files on the server,which files are created for log and how it is deleted on server ..??

Hi all, HI have a job in which there are two source datasets and i m trying to join these datasets based on three columns(mkt code,sale date and mob_no) and join conditionm is full outer. But when i am running a job it get abored and gives an error message main_program: Fatal Error: Destination &quo...

What is the data type? The display format is independant of how the data is actually stored; this is what I am assuming your problem is. What tool are you using to display your data? ... First i have taken the datatype as Timestamp,but the result was worng :cry: then i changed with varchar but stil...

ray.wurlod wrote:How? ...

Hi Ray,
There was some junk character in my source file,so i have used piped the source file with tr command and with tr -d option i have deleted that junk characher.............

Hi All, I have developed a job in which my source dataset1 has postdate column in timestamp which has format of yyyy-mm-dd hh:mm:ss and dataset2 has transdate column which has format same format as dataset1. but after joining these two datasets on Account_no, transdate format getting changed its in ...

mahadev.v wrote:See if this post helps. viewtopic.php?t=113640

Thanks this has helped me and i have resolved my issue with junk character/......

Hi all, I am extracting sequencial file of comma seperated and quote character is double quote.But there are some junk characters in the one of the columns.I want this junk character to be removed or can be rejected to track the records.If you have any idea ,how to handle this ,please let tell me. R...

wrong result means data in the target dataset inproper i.e. not matching with the source dataset