DSXchange

Once i sort the data, that duplicate records will be removed. I don't

want. I need send Duplicate Record in to target link( Error_Target). Can

u give me the query

My condition is that dupicate records store in to the Error Table ( Target_Sequential file) help me the query. If i use Aggregator Stage, is it show the duplicate records separately. Otherwise, if any condition for this, can u . I need two check these two colums AcctCode and DeptCode give me the que...

Hai, I have one problem. I need to check duplicate record from two column. If it is duplicate record, that record store in to Error Table. Ex: Name Age Raj 25 kamal 45 vinodh 40 Raj 25 Now , the dublicate record is Raj. This Raj record is send to the Error Table. How can i do that. Can any one help ...

Hai meena,

I am using my source is a timestamp. If u got it, How can u do that?

can u help me

Regards,

prabu

Hai, I have one problem. My Source column is AGG_EFF_SOURCE_DATE AGG_EFF_END_DATE This Column Datatype is Time Stamp. Here, my condition is i need convert Time Stamp DataType (MM/DD/YYYY HH:MM:SS) in to (DD-MON- YYY). EX: INPUT: 03/15/2006 OUTPUT: 15-FEB-2006. In my job i am using OCISTAGE_SOURCE, T...

That is i did. but it is not working. plz help me. How can i do that?

I expect all help. Plz help me. I want solve the problem.

Regards,

prabu

Hey Ray,

Really Thanks. My job is working properly. I really thanks to

everyone. Thanks, for ur timely help. In this forum really helps for all

beginners like me. Thanks guys. :D

Thanks

prabu

From an efficiency point of view, an Index() function looking for the first occurrence may be preferable. Index(link.column#1, "|", 1) = 0 And Index(link.column#2,"|& ...[/quote] Hey ray. Thanks for ur reply. my source column is AcctCode, Acctdesc,allocmethod, AcctDescr. For this...

Hey rk, Hai guys, I have one doubt. Example Coding: Input : Aravind Begin Case Case Count (Arg1,'a') > 0 Ans = 19 Case Count ( Arg1, 'a') = 0 Ans = 20 My Source Column is: Acct Code, Dept Code, Dept_desc, Alloc_method. Example Code: AcctCode, DeptCode, Dept_desc,Alloc_method 123 | ACCS | Account St|...

Hai, I am new in DataStage. I have one doubt. Example Coding: Begin Case Case Count (Arg1,'a') > 0 Ans = 19 Case Count ( Arg1, 'a') = 0 Ans = 20 We are checking for the PIPE ( " | " ) in the source, if we find any PIPE inside the data like ( Sur|esh | 2345 | taj), the whole job going to be...

kumar_s wrote:Has the MKS tool kit been installed?

Hi kumar
i have installed MKS
its working fine in local machine.but when i installed in other system i got error message. its not working in networking
Kindly give some inputs on solving this.
Regards
Prabu

Hi, Installing px on Windows XP service pack 2 I am having problem with the installation. ##I TFCN 000001 17:27:08(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I TOSH 000002 17:27:08(001) <main_...

Hi, When ever i read or write the data into the oracle 10G database i am getting following warning main_program: An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG I tried changing t...

Hi Istsaur, Thank you very much for your reply. Oracle driver installed perperly but again when i am viewing data from oracle stage i got follwing error i am using oracle 8i Kindly rectify the error ##I TOSH 000002 22:29:21(000) <main_program> orchgeneral: loaded ##I TOSH 000002 22:29:22(000) <main_...