DSXchange

VARCHAR worked ! ... Thanks guys! :D

Tried specifying the delimiters, record length in the seq stage. But it does not work.

By default DS takes Final delimiter = end, Delimiter = comma, Quote= Double. The datatype of the source file is CHAR for all columns.

I'm trying to load a sequential file created as output in a server job in a parallel job. I am unable to view load or view the data, the error that pops up is : ##I TFCN 000001 16:52:17(000) <main_program> DataStage XE Parallel Extender V7.0.0 Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc....

Specs just changed ... i have to compare sequential files now, and on parallel jobs !

Which is the best option i have right now Difference,Change capture or compare ?

How can I setup a stage variable ? .... Please explain ?

I need to compare each field in the record !

Environment variable problem ....its working now

I am trying to join columns from 2 transformers here. I am using a hashfile stage to make the join by manually giving a column and making it as the key in both tables. The log says: Timestamp:12/15/2006 5:03:33 PM Event type:Fatal User:balinea Message: TSTExtractRtlChnMerchNCDollars..x_trailer: |TST...

I am required to do it on Server. Can I do it? and How can I do this on parallel ?

I have two CFF files one from the Production and one from the DEV. Now I need to compare "records" / "fields" for these two files to check if the data from both the ENV matches. Some fields in DEV data are not in Production yet, in that case we'll have to tell the job not to perf...

I was counting the output row count of "l_to_x" going from the linkcollector to the transformer. I gave the count function in the transformer x_ORA.

Now that i removed the transformer the job is working perfectly, there is a considerable delay.

Another issue solved @ DSX .... thnx

I just removed the transformer after the link collector. , It works like magic again !! :D

I'll give it few more runs and let you guys know.

Didnt know that ! ..... I just typed everything. Anyways...

After i inserted the seq file the first time everything was fine , i got the perfect row count. But from the second run it gives the row count as 0.

Hmm ....

:D , Yeah I think that would do it .... I got abt 100 colums to copy+paste now . is there any other stage i can use to save all the time ?

I'm gonna do the copy+paste anyway now

Can we set a delay for a transformer so that other stages are executed before it? <a href="http://img356.imageshack.us/my.php?image=contrie1.jpg" target="_blank"><img src="http://img356.imageshack.us/img356/8336/contrie1.th.jpg" border="0" alt="" /><...

@Chulett Sorry for the confusion but... As far as my knowledge goes when we give @ROWNUM in the stage variables and map it to a column we get the output values in that column as 1,2,3,4,5,6,7,8,9.........14567. ( The number of that particular row ) I just need the value 14567 ( the number of the las...