DSXchange

ray.wurlod wrote:Fmt() is not available in parallel jobs. Had you bothered to Search you would have discovered that it's even easier than your "solution". Assuming you ...

Hi ,
Can you please provide me the solution , it will be a great help
Thanks

The QTY column with integer datatype of length 7 the non significant spaces on the left must be replaced zeros. If the incoming value is 388, the ouput should be 0000388. I have used the follwing thing in transformer but its not working Right(Str("0",7):Trim(Out_Agg.QTY),7) How to go about...

Getting Warning while running the job :

Seq_APPLICATION,0: Import consumed only 5bytes of the record's 16 bytes (no further warnings will be generated from this partition)

how to remove the warning

Job : File -----> Oracle Stage In oracle stage , using upsert method.The insert query is fine , then in the update query we need to update rest of the columns of previous record if column A and B values of new records matches with the old record column A nd B values. In this case duplicates are gene...

Hi, File ---------trans---------oracle table If the value read from the file is present in the oracle table for the perticular column , then delete all records from table with the same column value. Input File Column : A Target Clomun : B I have used the Write Method as Delete Rows , the issue is wi...

chulett wrote:You've said that already. Let's try this again.

How can you recognize the records inserted by the first job? ...

with the 4 column values inserted

chulett wrote:

amreesh_singh wrote:But I need to update only records which i have inserted in to the table using 1st job.

First mention of more than one job or of this particular requirement.

How can ...

i need to update only those records with the file 2 column value which i have inserted in the table in job 1

ray.wurlod wrote:The Oconv() that Arnd gave you won't give quite the result you seek. Its second argument needs to be "D2-DMBY" or "D-DMY[2,3A,2]". ...

Thanks for suggestion, How to use Iconv() and Oconv() functions in parallel jobs . If we cant use then wht's the other solution for the problem

how to convert date type(2008-03-12) to date type(12-MAR-08)

Hi,

The records are read from seq file and then inserted in to oracle table.
records are imported successfully but while inserting the records its rejecting them. I am not getting any warning in the log , its showing inserted: 0 ; updated : 0 ; rejected :9

Hi, I want to convert the string to date(DD-MMM-YY) format. The string is in the following format : 01032008 12:00 I am using StringToDate(DSLink6.EFF,"DD-MMM-YY") but its showing the error APT_ParseError: Parsing parameters "DD-MMM-YY" for conversion "date=date_from_ustring...

chulett wrote:Map them again. No rule against having multiple stages writing to the same instance / schema / table as long as you don't create locking issues. Or use another stage to combine the two streams before ...

Thanks

chulett wrote:Add two more Oracle stages. Link both from the 'third' transformer. ...

Thanks for the reply chulett . can you brief me on that , i could not get the point. I am having only two target tables and those are mapped to the two oracle stages.

Hi, The job have 3 sequential files , 1st one contains 4 columns and the 2nd one contains 5 columns and the 3rd one 2 columns. All the seq. files contains diff. data with no common column. There are 2 different target tables. 1st one contains total 6 columns ;4 columns of 1st seq file and 2 columns ...