DSXchange

Hi All,
Please can someone let me know why we are getting the below warning in one of my jobs.

cs}}}: When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.

Thanks in Advance
Eze_ke

Hi ArndW,
I checked each and every parameter of the job got failed and job ran success.
I found only change in the DS_USERNO.
Which I think is a random value will be assigned at each run.


Thanks in Regards
Eze_ke

ArndW,
I don't get the dsx log when job gets succes. I will get the log when job gets failed.
which parameters you are saying.
The one which defined in the job( datastage designer) or
on datastage configuration to run the datastage jobs.

Thanks in Advance
Eze_ke

Hello ArndW, Jobs are in UAT, I can't see the jobs in UAT with datastage designer. we don't have access to Datastage designer and director in UAT. So we check the log on unix side by pulling the dsx log into the log file(unix directory). Job got failed when it was supposed to run in the daily cycle ...

Hi ArndW
Same job I force started without even touching the job.

Thanks in Advance
Eze_ke

Hello All, One of the jobs got failed due to below error in UAT and the same job ran fine when I force started. Event Id: 66 Time : Tue Mar 14 15:00:14 2006 Type : WARNING User : dsadm Message : Ftp_topix_bnchmark_tgt,0: Warning: j_dst_gea_fctg_ge_russell_topix_bnchmrk.Ftp_topix_bnchmark_tgt: 500 'P...

Hi, I'm using the ftp stage in most of the jobs. In couple of jobs FTP stage is reading an extra records. which is null records. I want to know why it is reading a null record. If my src has 100 records then FTP stage is readin 101 records and one is is null record. Please suggest me how to solve th...

Hi reachthiru
I Implemented the join logic too. It didn't worked as there are duplicates in the key values.

What joing I need to use to read all the matching records from source even though the are duplicates values for the Key columns.


Thanks
Eze_ke

Thanks reachthiru!

I have tested with join stage too.
Still I'm not confident as we are having duplicates in the table.
I need to read each and every duplicate record.
Since my individual keys are in hierarchy Which join method I need to use




Thanks
Eze_ke

Hi Keith, My keys are dynamic and they have duplicate values. Since there are duplicates in lookup table I'm not sure I'm picking all the duplicate records. In my case I have read all the duplicate records in the table In my job when I'm doing lookup It is picking up the first duplicate record. So I...

Hi I have a source file In which there are four key columns which is going to do a lookup on lookup table. every indvidual looup key has duplicate values in the table. This four keys are in hiearchy Source Transaction_type Transaction_sub_type Asset_id If asset Id is populated then there should be v...

Thanks ArndW!

Could you please let me know how to add message handlers explicitly for each instance.

Is there procedure I need to follow.

Thanks
Eze_ke

Hi, I'm doing lookup on a table, Lookup uptable has duplicate values for key. and it is throwing below warning. Lookup_3,0: Ignoring duplicate entry at table record 1; no further warnings will be issued for this table I added this warning to Message handler and eliminated the warning. I want to know...

Hi,
I get the below error

Failure during execution of operator logic.

Fatal Error: Fatal: Connection to the remote host's FTP server failed, host name not found.

but in the job I gave the correct login ID ,server Ip and password.

Thanks
eze_ke

Thanks Kumar!
I'm to compile now, but still I'm not able to read the data from the ftp server.


Please help in resolving the above issue.


Thanks in Advance
eze_ke