DSXchange

if you have a||c and all are varchar fields , the second field will be imported as "Empty space". For other datatypes , this is not the case . There will be warnings and the records will be dropped if reject file is not mentioned. Nutshell:Varchar fields are read as "Empty spaces"...

if you have a||c and all are varchar fields , the second field will be imported as "Empty space". For other datatypes , this is not the case . There will be warnings and the records will be dropped if reject file is not mentioned. Nutshell:Varchar fields are read as "Empty spaces"...

thompsonp wrote:Do you mean the solstice or daylight saving long and short days?

Why don't you use a Calendar table and record these as attributes against each day?

Absolute right.

Can you please more clear about the calendar table concept. How can I proceed?

thanks
kamal

JoshGeorge wrote:Writing into a fixed width file? Is the 'rectangle box' appended to fields which are defined as type char? Set the APT_PAD_CHARACTER to space and see if that solves the issue.

I am not writing to fixed width file. The column in corcern is varchar.

Do you mean the Winter and Summer Solistices? The shortest and longest days of the year? That depends on where you are. I'm not aware of how one would calculate that. I would normally just look such a thing up in an almanac or ephemeris. Perhaps a Google search on 'solstice' would help. This short ...

For some stages like pivot and aggregator stage one of output column of has a special character (new line e.g one rectangle box) appended with output data. Please clarify me why these stages are appending a new line character? How can we rectify this problem? Note: We have checked the source data fo...

Is there any functions avaialable to findout the short day and long day in a year? Otherwise can i anyone explain functionally how can one find the short and long day in a year?

Hi all, I am using a Tera data multi load stage to extract data. In that there is a tab FastExport which asks for Max sessions and Min sessions. Can any body suggest me what is the optimum value that i can give and what is the effect of increasing or decreasing the maximum value. Iam using a four no...

One way of doing this will be to use an After Job abort routine . There are a couple of advantages that i see You will get all the rejected data that way , that failed the condition. Have a constraint on your XFM to output these "exception" records and in the abort routine use the record c...

Data Always needs to be partitioned !

Can an after Job Abort routine be used (based on the record count through the "exception" link) that will abort execution till there are no exception records . That way execution of next job can be controlled

Can After job subroutines be used to accomplish the same

We had a Similar issue and the workaround was splitting the ISNotNull and Comparison clause

Nutshell

If IsNotNull(Y)
Then
If (Y<>0)
<case1>
Else
<case2>
Else
<case1>

In Job properties there is a provision to read date in expected/input format .
You can set that to the required format and read the date , DS will take that as the date and override project default

Hi all, Iam trying to extract a decimal 16,2 value in Teradata as decimal 16,2 in data stage. The error iam getting is "Contents of phantom output file => RT_SC3867/OshExecuter.sh[20]: 5095602 Memory fault ". When i am extracting a numeric field it is not giving any error. What can be the ...