DSXchange

Could u please explain breifly, i am unable to get u

thanks

Hello,

I have the idea to remove the duplicates using the transformer
but the problem is to get the date values of all records
if u have any idea kindly suggest me how to derive the dates

Thanks

No, that would not happen

Hi All , my source is like this ID1 ID2 BEG_D END_D PRYR_BEG_D PRYR_END_D 1 1 1970-12-28 2003-10-11 1969-12-29 2002-10-12 2 1 2003-10-05 9999-12-31 2002-10-06 9999-12-31 If the current and previous value of the column ID2 is same I need to build the record set like this 1 st record ID values are sam...

Hi All, i want to change the row values to the values of difrent columns my source is like ID Type 1 Clerk 1 Accountant 1 Manger my taget should be the like this ID TYPE_Clerk Type_Accountent Type_Manger Type_Gm 1 Clerk Accountant Manger NULL if any one have any idea please reply back that would be ...

First of all thanks for u responce
I am not sure In this sceneraio whether both records will reject or single record

For Example
i have a data like this

10,AAA
20,BBB
20.BBB
30,CCC
in this my output should be the
10,AAA
30,CCC

The Id 20 has to be in the rejected file

Thanks

i want remove two records

Hello All,

in my source i am having duplicates,if any duplicates in the source i want reject those two records
kindly help me on that

Thanks

Hi I having a dought that what is difference between a routine and a function in datastage

Hi Ray, I done the same , Now i Know the which Source it is giving (this is giving in Column Import stage ) But this is not specifying the Columns Name , I expecting data in char,Decimal ,Big int ,Interger Interger fields are date in target I am using Routine to convert Interger to date I asked to c...

Job Details

I am importing from Schema file

SEQ File ---->Column Import ----->CopyStage ---->TRFM---> LKP --->TRFM---> Target (DS)

I am able to load the Data in to data set

Thanking in advance

APT_CombinedOperatorController,0: Invalid character(s) ([xFFFD]) found converting Unicode string (code point(s): [x0000][x0000][x0000][x0000][x0000][x0000][x0001][xFFFD]) to codepage ASCL_EBCDIC-1026, substituting

I am getting different errors for each time ontime it is giving ORCHESTRATE step execution terminating due to SIGINT error and another time it is giving Lkp1,0: Operator terminated abnormally: received signal SIGBUS error and Lkp1,0: Operator terminated abnormally: received signal SIGSEGV error Than...

i am getting the ORCHESTRATE step execution terminating due to SIGINT problem in my prodution environment and my job is not running it got aborted i tried many times and it is giving the following errors Lkp1,0: Operator terminated abnormally: received signal SIGBUS can any one help me in this Thanks

those special charecters are not constent our sorce as files because of that i am getting different type of non keyboard special charecters.
only one thing i have to do other than A to Z and 0 to 9 remaining charecters i need to remove from the string .
how to do that please guide me.