DSXchange

Hi All, I have a column called ADDR4 of type VARCHAR(40).It will hold the 4th Address line of an account. I am getting data as POSTCODE concatenated with STATE in this field. I need to extract the State from ADDR4. Here is the sample data ADDR4 ABCD M22 1 TQ ADDR4 AB CD BD 22 1 SW In all the cases i...

Hi,

What is the equivalent datatype in Datastage for S9(14).99.
It is a decimal field but i have ambiguity over the length?Is it Decimal[16,2] Or Decimal[15,2].

Thanks in Advance

Thanks
Raam

Rey,

May i know the process how you calculated the number of processes?

Hi, Here is the alternative way. If your input is of type STRING then try out the following method. SVmonth : If Len(DateVar[1,2])=1 Then 0:Trim(DateVar[1,2]) Else DateVar[1,2] SVDay: If Len(DateVar[4,2])=1 Then 0:Trim(DateVar[4,2]) Else DateVar[1,2] SVyear : DateVar(7,4] FinalOP : SVyear:'-':SVmont...

From manuals, i got that COPY stage perform better then MODIFY stage in this case. Modify stage will be used to change the data type of the existing columns but in my job i am not changing the data type, just dropping the unwanted columns. So i've used COPY stage in my job for dropping the columns. ...

Hi,

In my job i need to drop some of the columns from dataset. For Dropping the columns which stage will do good either COPY stage or MODIFY stage?

Both stages wil do the this task but in performance point of view,which stage will perform better/Fast?

Thanks in Advance,

Raam.

EXECUTE COMMAND Activity is at sequence level but i want to concatenate datasets at Job level.

Is there any specific stage to execute CAT command from Datastage job.I need to use the final created file(After Concatenating) for further processing in the same job.

Hi Friends, In my job,i need to concatenate two datasets into a single dataset.I know that for this we can use funnel stage but the problem is my two input datasets are in different formats(Having different fields and different lengths) so funnel wil not work in this case. Is there any best method i...

Hi Friends, In my job,i need to concatenate two datasets into a single dataset.I know that for this we can use funnel stage but the problem is my two input datasets are in different formats(Having different fields and different lengths) so funnel wil not work in this case. Is there any best method i...

Hi,

Can any one tell me what is the difference between importing meta data through ODBC table definitions and Plug-In meta data definitions options in IMPORT.

Thanks
Raamc

Hi, In one of my job, i am using the sort stage before the Join Stage.The files which are joining have matched records and job is successfull. But in my Director, so many warnings are generating as below. Join_27: When checking operator: User inserted sort "{natural="Sort_30:DSLink32.v&quo...