DSXchange

Hi, while using SCD stage I had given flat file option to generate surrogate keys.flat file is created using SKG stage in another job with a single value of key in it.Error is SCD stage is not able to read the flat file given.Keys are supposed to generate using nextsurrogatekey function. Error is Un...

hi,

what is API concept all about, how its related with DS,.

we have some DB2/UDB API AND TERADATA API stages ,please let me know the feasibility of these stages

when i googled it, i got something like C++ API, JavaAPI.... what are they?are they related to DS....

hi Mike,

thanks for ur comments,

if i seperately generate surrogate key using SKG stage and stores them in a file,so that i can refer them as a statefile inside the SCD stage? is it wat u r mentioning....if so, how DS keeps updating the surrogate key when it is in use...

hi Mike,

thanks for ur comments,

if i seperately generate surrogate key using SKG stage and stores them in a file,so that i can refer them as a statefile inside the SCD stage? is it wat u r mentioning....if so, how DS keeps updating the surrogate key when it is in use...

I need to Use SCD stage in data stage parallel 8. in my design, I have a source table which lookup dimension table based on primary key, and tgt table have startdate,end_date along with the Src table. inside the SCD stage there are options to generate surrogate key using flat file option.I need to k...

hi,

I need to read a XML file and load data in to a table using a Parallel job in 7.5.2 DS Edition.

Using which stage can the xml file be read and how that can be done...please let me know....

Hi All, Thanks for all your inputs. My intension here is to do an analysis on tracking the errors/warnings of a particular job execuation. This analysis should be done using the data related to the job run , which is stored in the internal tables(metadata tables). So any information on how to access...

Hi All, I have just got the DS Version 8 installation. I have heard from many that, in DS Version 8, the repository(metadata) is stored in DB tables, such as DB2. I want to know whether these tables are accessible to the user and if accessible how to get that information from those tables Please giv...

A one to one mapping which Extracts from Oracle Table, a transformer and loading into a table. The only input of source table is the table name and at the run time, the job should dynamically reads all the columns and loads into target. The importance of this job is to re-use the job for other table...

Hi ,

Have you ever heard of the concept of functioning space(FS) in datastage context. For example, a job is taking too much functioning space ..like that?

Pls post your comments

Thanks
Pulio

Thanks for your response.But still i am not getting how we can get the value into the Defaul value of a job parameter.Can u please give the sample code piece also?

Thanking
Pulio

Hi,

I have a requirement in which i have a file which has a COUNT value in it(There is only one record in the file).
In another job i want this COUNT value to be set as the default value of a Job Parameter. How can i achieve this?

Regards
Pulio

Hi, Please guide me on how to import metadata from an SQL Server DB table. When i tried to import , i selected import->Plugin Metadata definitions.But there is no option to select SQL srver.Options are for Oracle 8/9,Terradata,Informix,DB2 etc. Also which DB stage can we use to connect to SQl server...

How/where can i view the DSParams file? Is it possible to edit the file?

Hi chulett,

Thanks a lot for your valuable guidance

Regards
Puli