DSXchange

Hi all,
I want to have unique load id for each load.For next load i should have incremented value. This should happen at each load level. Hence i want to know whether we can increment the environment variable at each load level.

Thanks,
Prerana

ArndW wrote:What is the data type you used and how did you try to hardcode the date? ...

I dont have any input field to populate the date fields inn my oracle table so i am putting value like 1900-07-07 in the input for the date field.

Hi all, I am doing a job where I m getting 4 fields from the transformer (Before transformer stage there are some processing like lookup and all present)which are to be populated in an oracle table. Table has total 12 fields. There is no input fields for the remaining 8 fields and are populated by s...

Hi, I have a sequence which calls the jobs which loads the oracle tables . what i need is if the sequence fails after n number of stages then it should start from the first step. It should rollback the previous activities i.e.truncate the data from previous tables.How we can do that in the sequence?...

Hi all,

I would like to know about the total ETL architecture.
The best practices while designing the ETL.
Is there any document/site available to know that?

Thanks in advance,
Prerana

Hi,
I would like to know about the site where the datastage reusable routines can be downloaded?
Or is there any alternate system where i can have a look on different custom routines written for different scenarios?

Thanks in advance,
Prerana

Hi,
I updated the ip address in the .odbc.ini file in $DSHOME which solved my problem.

Thank you.

Hi all, I m using datastage server version 7.5.1 . And database is db2 on unix server. Both the datastage and db2 are on the same server. We have renewed datastage license, however we are getting the following error message when we are trying to connect to the database (view data from ODBC stage) Ba...

How to pass the parameters to UserVariable Activity where the paramerters to be passed are such as "-d -s #$DBName# -x ABC -u #$DBUser# -p #$DBPass#, d -s #$DBName# -x LMN -u #$DBUser# -p #$DBPass#" As the error i get is getopts: 0403-004 Specify a parameter with this command. the job para...

Hi.... Thanks for help Ray. But If I want the value 10 for M and 20 For F then the convert function is not useful.Is there any other way for that. Something like: 1.Convert("MF","10202",inlink.gender) I want M should be interpreted as 10 and F to be interpreted as 202 2.Convert(&...

Hi I want to know whether is there any function in the datatstage which can decode the values . Eg. Decode(attribute name,M,1,F,0) Means if the field value is M then it should be interpreted it as 1. And the same for the next field where if it is F then it should be interpreted as 0 in datastage.And...

Hi Anupam,
Thanks for ur help.
I still have same problems but trying to get rid of those..Ur logic is working fine.

Regards,
Prerana

Hi Anupam,
Thanks for the reply.
I implement the same thing which u explained but it is not giving me the output.The same input file is apearing in the output...
Why it is so...?

Regards,
Prerana

Hi.... I want to concatenate fields of the Same table or sequential file..... Consider A table having two fields Movie name and actor..... Now there can be many actors in a single movie then first i have two sort the table or sequential file and then For the same movie name if there r many records t...

Hi,
the query for us is how we can generate surogate key for output sequential file and for output database table?