DSXchange

Kim / Ray,

I have tried to get the usage analysis from Manager however when the jobs are selected the Usage Analysis is greyed out?

Do I need check the to collect metadata check box from withing Administrator?

What my intentions are are to be able to query the metadata easily with refrence to which jobs use certain tables, variables, column_names, stage variables.

Ray, I have checked and double checked that the jobs box was ticked and all jobs were selected, the update takes seconds, which makes me dubious that there is any data to Update. Is there enything that needs to be turned on inorder for when the jobs run to gather the meta data? Also you mention that...

Could some one please help I am trying to export DSJOBS data from the a project to the Oracle schema created from the Reporting directory when DS was installed. I am able to view table definitions and alike but no Job data from DSJOBS, do I need to turn on an environment variable to enable the infor...

Hi There, I have been running a few jobs couple of datasets one single join hashed and partitioned on key field. The key field in one DS is varchar 35 and the other is varchar 17. Without a transformer to trim and chage the varchar35 it takes an eternity and after the transofrmer is added it speeds ...

Thanks,

Please excuse my ignorance but I don't seem to find a wrapper stage in my pallette, even when I look to customize my pallette.

Is this and external function ?

B

Thanks ArndW,

I am struggling a bit to get this string built in a transformer, am I corect in thinking that I can't do this in a loop in a transformer.

Can any one offer any help to get me started.

Thanks,
B

mcs@rajesh, No problem, We have a rows of data i.e. Start Date , End Date, value 1, value 2. I need to calculate the months between start and end date (which I think I have got through a transformer). I then need to duplicate this row based the number of months between the two dates. So if the diffe...

I have a requirement to be able to duplcate rows in a DSet based on the number of months between two dates. I am running out of options. Can DataStage do this? is it possibe (if some one could point me in the right direction)? If not I guess it would be a case calculating the months difference in Da...

hamzaqk i don't think it is "Doh", Ray said this will return 0 if the string does not match. I therefore thought that it would return 1 if it did match. All too often on this forum people assume the inital posters understanding of DS should be excellent, and lets face it if we are posting ...

Thanks Ray, I may be asking a little too much but.... How would you implement if valueA is in (1,2,3,4,5,6,7,8,9) by fitlering reuslts in a filter stage or transformer, without writing... To_Transform.ValeA = '1' Or To_Transform.ValeA = '2' Or To_Transform.ValeA = '3' Or To_Transform.ValeA = '4' Or ...

Hi there, I have tried searching on this but as many things seem to be named dirrefently in DS to Oracle I have had to post. I would like to know the way of defining and IN list predicate in a transformer. i.e. Oracle code ....... FIlter where value IN (1,2,3,4,5,6,7,8,9) Can some one please shed so...

Josh yes I am using a hash partition, is this the best way ?

Yes ray I have checked the partitioning and it is sorted and partitioned on UIDCONTRACT.

What I want to do is to remove the duplicates based on UIDCONTRACT, and obtain the first row i.e. the row with priority 1.

I thought about using an aggregator stage bu that just brings back all the rows as I cant leave out the description.