DSXchange

Hi, In some of my jobs I need to take a lookup of file (Text file) with around 4 GB of data. (1) Hashed file stage wonot accept 4GB of data .So,I am going to Table lookup option instead of Hashed file.Is there any other way to do the lookup? (2) What is the solution for performance issue. We are usi...

Hi, In Serveredition 8 no special stage for remove duplicates. To remove the duplicates on column by using the stage variables by, SvCurr=SvPre link1.col1=SvCurr If SvPre=SvCurr then @FALST else @TRUE . Put this result in one more stage variable. and Place this stage variable in the constraint. Befo...

Hi, If i need to remove the duplicates on 1 column by using the stage variables by, SvCurr=SvPre link1.col1=SvCurr If SvPre=SvCurr then @FALST else @TRUE by using this logic I got the solution. The requirement is to remove duplicates more than 1 column How to implient this remove duplicates by using...

Hi, I am facing following problem. I have 4 target columns like Ext_Date,Day,Month,Year. In the Ext_Date column I need to populate the Date format(DD-MMM-YYYY) by using system date minus oneday. For this I taken ,Oconv(Iconv(DATE.TAG(@DATE - 1),"D-YMD[4,2,2]") ,"D-DMY[2,A3,4]"). ...

Hi,

What number we need to put in OCI stage under Transaction Handling- Row Per Transaction Option.

At present we put zero as Row Per Transaction.We can put any number or is there any process for this.

Any one have an idea please suggest me on this.

I checked with UTF-8 option.Still its giving special character at the end of data.Any one have the solution for this.

Hi, I am facing following date conversion in my job: Source data in the format: 26062008 (DDMMYYYY) I required output as in oracle date format and that date is last day of that month. I tried this : Iconv(MONTH.LAST(Oconv(in_Trns_Check.XTRCT_DT , "D-DMY[2,2,4]")),"D-DMY[2,A3,4]")...

Hi,

How to get the system time (with time stamp) for all the records when the job started.I need to populate this to target column with data type as DATE.

Any one have the solution please provide.

Regards,
Arshi

Hi all,

Thanks for your solution.Finally accepted Loopback Adopter IP as the HOST.But I am facing another problem,

Its giving the message as:

Project expirary date '-470/1/71369' is not unrecognisable.

Any one have the solution for this.

Regards,
Arshi

Hi all,

Thanks for your solution.Finally accepted Loopback Adopter IP as the HOST.But I am facing another problem,

Its giving the message as:

Project expirary date '-470/1/71369' is not unrecognisable.

Regards,
Arshi

Arndw,
I given all the ways like computer name,localhost etc.

But it not working.

Regards,
Arshi

Hi,

This is the message I am getting,

Failed to connect host : project:UV
(The host name specified is not valid, or the host is not responding(81011))

I checked all the datastage services are in running status.

Regards,
Arshi

Hi,

I installed datastage 7.5 server edition in my laptop.In the host I given the computer name and omited the user and password.

But I am unable to connect.Any one have the solution please provide.

Regards,
Arshi

Hi,

I have the requirement like,

INPUT

COL1

ABC
ABC
XYZ
ABC
XYZ

I want the OUTPUT as,

COL2 COL3
ABC 3
XYZ 2

Can you tell how to implement in datastage.

Regards,
Arshi

But other jobs are running fine