DSXchange

Kumar

Thanks for the suggestion , I will try it out.

rekha

kumar_s wrote:Hi,
You can try an option by reading it as a character and checking after triming the leading zeros. If the length of the value becomes more than 14, you can seperate those rows. Else convert to decimal.

-Kumar

Just to add more to the post when i used DFloatToDecimal (field,"round_inf") with field value being 1.40140663574703500E+06 and dump into test file al i see is ?00000.00000000 Hi I am using DFloatToDecimal (filed,"round_inf") to conver the source field with value ex: -1.401406635...

Hi I am using DFloatToDecimal (filed,"round_inf") to conver the source field with value ex: -1.40140663574703500E+06 and put the result into FIELDOUT which is decimal[14,8]. FIELDOUT 14,8 will not be able to hold the result of DFloatToDecimal (-1.40140663574703500E+06,"round_inf"...

Hi I am getting strange output while using the custom built opeator that i developed. I developed a new parallel stage and when i used this in the parallel job , I am getting only 'NULL' as output for all the columns . to me it looks like the input that I gave is not being taken. job is some what li...

The Join stage requires input to be sorted on join key(s). You have an upstream sort that does not sort on the join keys, or violates the requirements of the Join stage in some other way. You have to figure it out. Inspecting the OSH is a good starting point. Thank you Ray I got it .. down stream i...

Hi I am getting the warning below , i am trying to join two tables on two keys and for the join i have taken left outer and used hash, sort unique as the properties. I am not able to understand why this warning is coming. "Join_89: When checking operator: User inserted sort "{natural="...

The message means that the FTP service is either not configured or not enabled on the server. There must be an entry for it in /etc/services, and its port number must not be blocked by a firewall. Thanks ray you are right , actually for my project i do not need remote access so i disabled that opti...

My suggestion was made in the absence of that new knowledge. If you use the Continue rule you could test the result of a lookup column, which should be null if the lookup failed. Make sure not to test a column that might actually return nulls. That is, the same technique as you might use in a serve...

Run the rejects link into a Copy stage and make a link from there into the Funnel stage. You should not (can not?) need to name virtual Data Sets; they take a name based on the link name. But wouldn't it be easier just to change the Lookup stage "Lookup Failed" rule to Continue? Then you ...

Hi I have job where in i want to funnel reject link of lookup and the actual output of lookup after doing some tranformation. lookup --->transformer--->funnel and to this funnel i want to add the reject dataset from lookup. I tried making the reject link as .v so that i can reuse. but i am getting e...

I do not know if it helps try this where clause below where t1.dt_id >= date '2004-07-31' and t1.dt_id <= date '2005-07-31' In teradata i guess it is looking for type cast. Disclaimer: I know nothing of Teradata SQL I'd guess the t1.dt_id casts from a julian date to a char for this comparison where ...

Hi I am trying to use the wrapper stage, and i am getting the error below "No Operator defined for Stage Type testwrapper" My intention is to try with a simple unix command and then replace with my real logic. All I did was read the given file using testwrap apply unix command and dump it ...

I got it now .... the search in forum gave me old postings which are helpful Thanks to all This link does not seem to work ....... can any body view this link The link would have worked fine if it was posted properly as a link. The way it was done, it needed to be cut-and-pasted into the Address lin...

This information was really helpful, thanks for your time I'm not going to cover the differences, that you can read from the 4 years of posts talking about them. I'll answer why someone would build a server job in an environment where only parallel jobs were built. Server jobs are extremely flexible...

This link does not seem to work ....... can any body view this link

logic wrote:Hi rekha,
Search the forum , you will find lot of stuff Also read the following post,

Code: Select all

http://www.dsxchange.com/viewtopic.php?t=95903&highlight=search+posting

A quick answer to your question would be performance