DSXchange

I have date comming from source, i want to take the min and max for date i am changing the timestamp to secondssincefromtimestamp in the transformer then taking it into aggregator do min / max then take it to modify stage where iam using the following specification to chane it back to timestamp COL:...

I am Using the following code in the specification COLUMN:timestamp=timestamp_from_seconds_since(COLUMN) Error what i get is: """"" main_program: Error parsing modify adapter: Error in binding: Parsing parameters "" for conversion "timestamp=timestamp_from_sec...

Hi deepak, i used the following derivation COLumn:timestamp=Timestamp_From_Seconds_Since(COLumn) but still i am getting the error main_program: Error parsing modify adapter: Error in binding: Parsing parameters "" for conversion "timestamp=timestamp_from_seconds_since[****************...

Hi below id the code for one of my coulumn in modify stage COL:timestamp=TimestampFromSecondsSince(COL) converting integer to timestamp is it correct??? as i am getting the following Fatal error main_program: Error parsing modify adapter: Error in binding: Unknown conversion: TimestampFromSecondsSin...

i am getting 5 warnings
incomming 103631 rows --- > written to Seq file 103631

still i am getting the same warnings

""""Detail_Tfm,0: Conversion error calling conversion routine timestamp_from_string data may have been lost""""

Hi I did a search with the error in the forum but could not resolve the issue Warning:--Detail_Tfm,0: Conversion error calling conversion routine timestamp_from_string data may have been lost Ora----->Tfm------>seq I am extracting from Oracle view and writing to a sequential file One of the date fie...

hey dude

i aslo came accross this but no one in this forum has replyed for that

let us know if u get any solution to this

iam able load with server Job but the parallel Job truncates the columns

Hey guys no one has suggestions nor has come accross like this

please Suggest

when i use DS Server Job iam able to Load with out any truncation
iam using SQL Server 7.0(Dynamic RDBMS Stage)
please Suggest

i still have the same problem Data Truncation while loading into SQL Server please suggest

i get the out put in the sequential file as expected (no truncation)
its only when iam trying to load in SQL Server (Table)

Hi

I checked the Input Data,which is fine.No special charaters
Also tryed hard coding the values in transformer stage but still i get the truncated data in table

all last charcters of character fields are being truncated

please suggest

anntaylor,
there are 1195 records in the table.

Thanks
Eze_ke

Hi All,
I have a question on join stage.
I have 6000 records in my source and I'm doing left outer join with one table, after the join I'm getting 6039 but I should get only 6000 records.
Can some please explain me why it is happening?

Thanks In Advance
Eze_ke