DSXchange

Hello, it's me again:)

Maybe you know, how can I concatenate many columns from single stream into one string?
but I don't want to write in every time: DSLink1.colA : DSLink1.colB : ... : DSLink1.colN !!

Hello For example, I have 4 columns in my source table. In every column NULL value may exists. I want to replace every NULL by 0 (for example). Is there some solution to replace NULLs from incoming rows at one time for every 4 columns or is the only possible solution is putting condition in transfor...

Hello again, I decide to implement dimension with two kinds of SCD types (1 and 2) in one dimension table (some columns are type1, some type2). My approach to this issue is: 1) divide table into two parts (with columns type2 and colums type 1, both with natural keys) 2) process records with type2 - ...

I think the question was more about this type of impression. I would like to hear others opinions about advatages and disadvantages.

correct

Hello! Some time ago there was a discussion about multiple SCD types in one dimension. Original post is here: http://www.dsxchange.com/viewtopic.php?t=93674&highlight=scd The main conclusion was that Type 1 or 2 is for whole dimension, not for single field in dimension. Recently I have read Kimb...

Arnd, I have already done it! But I have not found entry about code page! Maybe you know what must I look for??

sory Arnd it was silly question!! I found it

You are able to generate reports using the command line. You could write a job that gets the job list, then looping thru that, run the create report command for each job. OK! I can do it, but how can I generate report from job which exist on server (UNIX) and I have my client on another machine (Wi...

Luk, edit the code setting right at the beginning of the .DSX file and you will be able to import it.

Arnd, I have already done it! But I have not found entry about code page! Maybe you know what must I look for??

Propably I agree with you, but Ia have vo access to MetaStage sostware

I posted a batch file that will do a job report for every job on ADN. I prefer JobReport written by Tony Curcio. I think it creates a nicer document. So created a wrapper for his routine which will do all jobs and all routines. I wrote the routine part to look the same as his html. It creates and i...

Thanks

Hello!

It is known that it is possible to generate job report (in Designer) in HTML or XML!
But is it possible to generate such reports for many jobs in one time (without need to open each job in designer and generate report)??

Regards

Hello!
When I was using Reporting Assistant in manager and updating project information, following error occured:
and my DS Manager is closed.

What does it mean and how can I fix it??
Thanks for any help.

DataStage is installed on a Linux Server. You must have ODBC source and drivers locate on machine where your DS server is located!! Created a systen DSN in the local machine using start->settings-> Control panel->Administrative tools->Data Sources(ODBC). And , I think, you have created system DSN o...

how to extract column names from the metadata in the Repository,

exactly that was the core of my question - I presume that in DS I can not do this!