DSXchange

@Chulett @OUTROWNUM gives all the row numbers as a seperate column, but I just need the total number of rows in a column. Then again I have to plugin a AGGREGATOR to take the last value of that column ( and this does not work with the constraints I am giving). @DSguru2B You cannot do that while the ...

I know you guys would like to shoot me after I say this but .... I dont have any tool to run a query on , I am trying to get one installed. Anyway the Team has decided to change the Source timestamp to another field which makes the job run well ( atleast for now ). No changes can be made to the tabl...

I am using this to get the link row count


DSGetLinkInfo (DSJ.ME, "Transformer_56", "l_to_sq", DSJ.LINKROWCOUNT)


But in one job it gives the output as -9. I really dont get why it happens ?

<a href="http://server6.theimagehosting.com/image.php?img=ORA9.jpg" target="_blank"><img src="http://images6.theimagehosting.com/ORA9.th.jpg" border="0" title="The Image Hosting" /></a> Thats the table metadata. and here's the output <a href="ht...

@Chulett Yes we are using the combination of 4 columns. I cannot post the DDL for the table as I dont have it and there is no way I am getting it as the DBA is out of my reach. @DSguru28 We are writing only 1 row to the table when we run the job, so we cant have the same DSjobstarttimestamp or curre...

I will ..

I need to do it for about 50 tables with different column names. So i need to keep changing the column names for every job.


I am concatenating the columns and again pulling out substrings from that so if i happen miss a column its gonna be a mess.

I have to CONC 25 columns so thats bad news for me, Anyway..


.... thanks Chulett

I need to concatenate the first 10 columns of the source data.

say the columns are 1,2,3,4,5,6,7,8,9,10 then i'm using 1:2:3:4:5:6:7:8:9:10 , is there a simpler way to do it so that i dont have to enter all the column names ?

When we are inserting the rows there are 4 primary keys in the rows. The combination cannot be the same because their derivations are "DSjobstarttime stamp" , "Current date and tiimestamp", "another Timestamp from the source" and finally a "ID" . "ID"...

The constraint was a TYPO. i am using "<>"

I just need the highest value of the row count . ie: if there are 12345667 rows in teh column then the value returned should be "12345667". How can i use @OUTROWNUM to get this ?

I am choosing some rows from a column in the transformer with a constraint and writing the output to a sequential file. The constraint is l_to_Tform.MG_NO [1,1] = "#" ie: when a row starts with #... reject it. I need to get the output row count. Is there a way to do that in the same transf...

@Chulett ... U got us :wink: ... We work on the same team.... just on different jobs and locations, and thats why u guys have 2 confusing threads ! Yeah, we're workin on it as of now and NO, we didnt escalate the situation to the DBA.... and YES, i think we have figured out a solution .... will keep...

@ PADDU, That field is not the primary key for the table and as of now but it was marked as the key when I loaded the table definition. There were 4 keys when loaded the table definition but we didnt want them as keys so I changed the "KEY" option to "NO" for all of them and I us...

There is only 1 record being inserted. We are inserting a row into a table everytime we run a specific job. It kinda leaves a log stating it has been when it was run.