DSXchange

Well done. ISO 8859-1 is sometimes called "extended ASCII". Please mark this thread as Resolved using the green button at top. Yes.. ISO 8895-1 is 8-bit single-byte coded graphic character sets which is sometimes called "extended ASCII". where are actual ASCII is 7-bit.

Issue Resolved..

I used ISO 8859:1 standard for only sequentail file stage and made unicode in the extended column in database stage.

are there any NLS standards which can the retain the same format as table data when i load it to sequential file.

Hi all, Requirement is to call a Teradata stored procedure, to do so, we are using DRS stage. Dataset will the Input for this job. In DRS stage, under the user-define page we are using the below syntax to call the teradata SP . CALL databasename.sp_name ( : parameter1, : parameter2, : parameter3 ); ...

just4u_sharath wrote:kill phantoms and try again

what are phantoms ? how to kill it?

hi, i want to know the realtionship betweent the TPUMP parameter values, such as pack,sess min, sess max, latency and statement rate. What kind of relation we have between all the above said parameters. for an example, if i am increasing the pack value for some thing. how this varied pack will be re...

Hi all, I am running a job with source as MQ and target as teradata, between many transformations/business rules has been implemented. My question is, what are the parameters will affects the performance of the job. How to tweak the performance of the job? 1. By tweaking some of the parameters in TP...

ArndW wrote:Can you export your column definitions to the metadata, then load them into your column generator stage? Usually the reason is that the column really are not in synch, so doing this would guarantee th ...

hey... its solved. Since funnel stage is case sensitive this problem arrived.

In Funnel stage-output page, input columns(columns from row generator) in the left pane are not visible.
we have two input links to the funnel stage and i have checked the metadata of both the input links and output link, they are all in synch.
may i know what is the reason for the above problem.

eostic wrote:...and if you have a Sequential or dataset target, do you lose records?

Ernie

Yes, same behaviour.

The more I think about it, and now see also that this is a 7.x implemetation (sorry I missed that before), it simply may be the need for end-of-wave in an EE scenario. EE is designed at it's core to handle incredibly large volumes of data. As part of that strategy, it does buffering during pipeline...

I've used -1 and see no detectable slowdown in read speeds. How did you measure this? ... This is what my observation: The total messages in the queue is 480. scenario-1: ----------- When i run the job with message limit=480 (non-continuous mode), the job is getting completed within 1 minute. scena...

I need a help related to Message Queue stage in a DataStage Job. Agenda is to make it continuous run, for this in MQ stage under the tab output the value for the Wait time is '-1'. if this is the case jobs are taking more time to run and to process number of records as well as to commit it to the ta...

hi all,


I need to join two files, file1 contain col1 and file2 contain col2, i need an output in such a way that the output file should contain col1 | col2 seperately but in a one file.

hi, pls convert the following SQL queries to Teradata SQL. 1. DATEDIFF(day,dateadd ( dd , ( r_update_date % 1000 ) - 1 , convert ( datetime ,convert( char(4) , r_update_date / 1000 ) + '/01/01') ) , GETDATE()) > 90[/b][/i] 2. datepart(d,dateadd(day,-datepart(d,getdate()),getdate()); Rakesh nc