DSXchange

I have 10 records in input file. I extracted using sequential file stage and kept into another sequential file stage. I want to find the Record Status for all records. for ex, if a record is processed with Warnings it should be flagged as 'W' if a record is processed with Errors then it should be fl...

I have 10 records in input file. I extracted using sequential file stage and kept into another sequential file stage. I want to find the Record Status for all records. for ex, if a record is processed with Warnings it should be flagged as 'W' if a record is processed with Errors then it should be fl...

I have two input files here, Before_file1 & After_file2(sequential file stages). Now I want to compare these two files and to get the MODIFIED, NEW-INSERTED & DELETED records. I know this problem in Parallel Jobs, by using Change Caprute stage. But I dont know in server addition. In my curre...

suppose you have 4 nodes in a configure file, then i want to find out which node is faster other than these

Plz reply for this

Hi Venky, [server will work fine and dont think so px will execute on windows platform..it needs unix to support...chek it.... ] We can do many things like job design,view data, compile of jobs except running the jobs on windows also. i am not asking about the execution. Atleast to view source data ...

Hello, I installed Datastage 7.5 on windows 2000 professional. Server jobs are running fine. But on PX, in any stage if i tried to view the data, is saying: "This job is currently not runnable on this plat form". I know that DS 7.5 version will not run on windows but atleast we could do fe...

Hi, I installed Datastage 7.5 version on windows 2000 professional on personal computer. Oracle is 9i. I am able to import to table defintion in the job from oracle table but could not view the data. The following error is getting. " emp_read.oracle_oci_0:ora-12154:tns could not resolve service...

Hi! I need some information here. Is Datastage Enterprise Editions(latest versions like 7.1,7.5.1A, 7.5.2) runs on Windows OS? (please specify windows flavours like 2000 server, XP, Professional on which DS would run) If any one have time, please provide information for configuration details on Wind...

Hi! I need some information here. Is Datastage Enterprise Editions(latest versions like 7.1,7.5.1A, 7.5.2) runs on Windows OS? (please specify windows flavours like 2000 server, XP, Professional on which DS would run) If any one have time, please provide information for configuration details on Wind...

Hello,

Job locked.we r not able to unlock it from director neither administrator.

Can any one guide me the ways on how to unlock the job.

Thanks,

Regards,
iamnagus

Hi Here i am sending the SOURCE data once again as earlier one is getting a bit confusing select TRIM from raoridbf.STG_VIP_INV TRIM -----------------------------------------------------------------------------------------------------------------------------------------------------------------------...

Hi kumar_s, SOURCE.trim(source field)=TRIM.code Here TRIM is lookup table. Here i am pasting lookup & Source data Lookup Table select * from raoridbf.trim TRIM_ID CODE DESCRIPTION ----------- --------------------------------- 300 TOURING TOURING 301 PREMIUM PREMIUM 302 BASE BASE 303 Model equals...

Hi, I have logged in as admin only i hope. I will find out about the user previleges from concerns and update in the forum. Or if i have not logged in as admin, then for what kind of user previleges i need to raise for? or kind of settings in Administrtor i need to set if i have this option? Regards...

Hi,

The same query is able execute in the DB2 Client database. I am getting this issue from datastage.

Regards,
iamnagus

Hi, I need to delete or update a record from DB2 table. My job design is like this. DB2 API stage--------->Transformer-------->DB2 API Stage (To read the table) (To assign a value (To update or Delete) Into stage variable) Qurey(in Second API Stage): 'DELETE FROM raoridbf.model WHERE (raoridbf.model...