DSXchange

but the best is googleing for some unix file comands

that's right but the second link "todelete" has 'D'=toFilter.UPDT_TXN_TYPE_CD. so does it means all rows with D should go to this link?

ask ur manager about DSA's (data sharing agrements) or any document if the feed is comming from another system.

or openup the sequential stage which is using this file and have a look at columns then click view data,if u succeed then u can save this info as table defination then ur done

the values of toFilter.UPDT_TXN_TYPE_CD are either I or D as you said if the value of toFilter.UPDT_TXN_TYPE_CD = D then the rows has to go to the link todelete, but couple of rows with D are showed up at the next xfm(fromfilter link) and here his is deleting records from the table if the value is D

Hi, my previous developer uses the following constraits in the xfm which is confusing me ..pl help me to understand this . the the following two links.none of them are rejected.. link constraint fromfilter ('I'=toFilter.UPDT_TXN_TYPE_CD) or ('D'=toFilter.UPDT_TXN_TYPE_CD) todelete ('D'=toFilter.UPDT...

i entered some date into XSl sheet in the format 02/09/2005 and saved it as .CSV then ftp'd the file to the server and RAY the column can accept date as 02/09/2005 (i have one more column as date and it's accepting the derivation DATE() ) although it look like stright forward ,but some how throwing ...

Hi , i am trying to load the date field from source into target column as it is. source is flatfile.date format is MM/DD/YYYY, target is oracle9.2 column is defined as DATE. the following error raising , while processing column "Call_Start_Date_Time" Value treated as NULL Attempt to conver...

look's great but i have small doubts 1)retrieves the max. cumulative of existing vehicle from the table. Also adds a flag P -- how to achive this. 2)reg stage variables CumTimeOf and PreviousVehicle how to set them with current feed values ( am i sounds reasonable). i am very much thankful for your ...

Hi sonia,
first let's look at the first feed

as u said my o/p looks like

Vehicle Name | time_on | cumulative_time_on
A | 1 | 0
A | 1 | 1
A | 1 | 2
A | 1 | 3

can u expalin me how to achive this ?

thanks in advance

thanks. but i can't use aggregator stage becuse i have to populate each and every record for every vehicle ( I can't group vehicles i.e if vehicle A has 3 records ,i need to populate all 3 in the target ) with cumulative_on_time and my target is Oracle9.2

hi friends here is my problem. my source is hourly feed which has fields like key_off and key_on. in that feed each vehicle may have multiple records. the time diff between Key_Off and Key_On is ON_TIME for each vehicle. here i need to calculate cumulative_on_time for each vehicle . for example the ...

Thanks Ray...

Ken, the output came like 02025AM ,but i want it like 02:02:5AM

thanks

friends i have 4 fields as HR,MIN,SEC,AM_PM_Flag.

how to concate these fields to get time stamp like HR:MIN:SECAM_PM_FLAG. i tried with the regular : but all i got is HRMINSECAM_PM_FLAG.

thanks for ur help

I am trying to insert data in to tabel which already has some data from .csv file. in the oci stage after defining the columns ,if i click view data error is comming for the last column ORA-00904: "PID_TYPE": invalid identifier. for test if change the columns order then also the error comm...