DSXchange

hi ray i want the duplicate row from the source sequential file to be captured .

i tried that but i am unable to capture the reject rows source(SF)----->transformer----->hashfile (reject hash file) if i mplement the job design as this way i am not able to capture the rejected row.After the trasformer the rows from soure are passing directly to the target hash file.but when i vie...

can any one tell how to capture the duplicate reject rows in the sequential file.

for example

source

rollno,name
101,pradeep
102,arasan
101,deepu

in the reject i should get one row after implementing the hob design through datastage.

Thanks for all your replies ,i spoke to the clinent and went for the equal to function then the result was accurate. previous i was using srvc_typ_cd_id<>'A' or srvc_typ_cd_id<>'Z' ...... existing except (AZNIP) remaining srvc_typ_cd_id i took and implemented the equal to function in thje derivation.

yes,as you have mentioned i used the same in the SQL.

when i fire the query it is resulting the result as 5.8 in the sql.same thing through datastage it is resulting sa 20.6

Thanks for the reply but i tried with AND function also i am not getting the exact result is there any other function in datastage to do the NOT IN function

I am using NOT IN function but the result is varing when i implement the funtion through datastage where us when i try to do in sql server using NOT in function i am getting the correct result. can any one suggest me where i went wrong If (SRVC_TPY_CD_ID<>'N' or SRVC_TPY_CD_ID<>'A' orSRVC_TPY_CD_ID<...

hi kumar, complex trasformation also can be handled through sql server query level and called through datastage since source and the target is the same data base. loook up can be performed by writing the userdefined sql query through joins. is there any other point we can add on? they are asking us ...

My soure and the target data base is same sql server. At one point the data stage job for loading a Job takes 6 hrs through datastage. the same job through store procedure if we call in the data stage it took only 3 minutes. From the client end there are asking every thing if we handled in the store...

I have 681685 records at my source .(user defined sql query from the combination of 3 tables) The target table contains 705403 records. source columns are directly mapped to the target table in a straight move manner(the primary key field between the source and the target is only one column). the ta...

check with the @INROWNUM=10188 so that u can able to identify why u r getting the error msg.

regards
arasan

In my job design i am implementing one to one mapping. source>>>>>transformer>>>>>target source table is comming from one database and target table is from another database.The target table option is insert new or update existing.It takes 10 hrs to load the data.can any one help me to improve the pe...

I am getting this Phantom warning can any one suggest me how to get rid of it.......... DataStage Job 1095 Phantom 2892 Program "JOB.166157985.DT.1400823392.TRANS1": Line 376, Division by zero, zero returned. Program "JOB.166157985.DT.1400823392.TRANS1": Line 377, Division by zer...

obviously u will be getting excess records I dont think so any Bug in join stage.u are using left outer join the link from left all rows u will be getting it. and the matching records from the right link.just see through the link ordering.

1.Data set it works through DS engine.
2.copy stage it will be very use full for taking DUMP. you can check data is passing properly.