DSXchange

HI, Thanks for your kind Reply. my problem is when i have a look file with these two columns and source file with one Vendor no, i have to do comparison that in between which range it falls, if it falls in between 2000000 2009999 then i have to assign the TYPE field as SAP. Now my question is when u...

Hi, Can anybody help me on this pleas: I have a lookup file like this: From Till TYPE 2000000 2009999 SAP 3300000 3309999 Transport 3600000 3699999 Transport 4600000 4699999 Transport I will have a Source File like this: Vendor No Type 2000001 2000050 3600002 Now in transformer i need to look up for...

HI, I have a job say X. After running this job i need to dump the resultset of the job to a xml file. how can i do that? One more case is. :roll: There are 5 jobs each in sequence after running all the jobs i need dump the resultset like "Job 1 has ran at this time to this time" and so on....

Thanks for the info, but does any body worked on SUNOPSIS tool here? can anybody tell me what is the difference between SUNOPSIS and DS?

Can any body give me Architecture of DS?

Regards
Shiv

Thanks for the info, but does any body worked on SUNOPSIS tool here? can anybody tell me what is the difference between SUNOPSIS and DS? Can any body give me Architecture of DS? Regards Shiv Hi Been worked with Both Informatica and Datastage I had found Datastage much better than Informatica. Its ve...

Hi, Can any body help me to answer these questions. How do you get log info into a file? What is isolation level and when do you use them? What is before job subroutine/After job subroutine? When do you use them? How do you clear the lock of a job? How do you backup and restore the project? What is ...

Hi,

I have a Peculiar quetion here to ask all of you.

Can any body tell me how DS is good when compared to any other ETL tools like Informatica or SUNOPSIS?

Can any body answer to me in detail?

Regards
Shiv

Hi, As per my knowledge you can install IBM i-Series what ever the version is, then you will get 32-bit ODBC Driver with it. Go to Administrator tools in setting control pannel and create a new system DSN using this 32 -bit driver. Parameters are IP address, user name and password and Library list. ...

Hi,
I have created a DS job on Solaris server. It compiled without any error. But when i started running that job it doesnt run at all. And it wont give any error also. Can any body tell me why this job is not running?

Regards
Shiv

Hi, I have Two jobs Job A and Job B. Jab A and Job B have to be in sequence, so i will create a sequence job. Job A has a parameter with Path name of the Hash file. when i run this sequence job its status it shows as running but not giving any outputs. Can any body tell me whats wrong over here. reg...

Hi, How can i handle this condition in DS? If (DSLink47.FACode = "11" OR DSLink47.FACode = "12" OR (DSLink47.FACode="13" AND DSLink47.SM_Code !="24" AND DSLink47.SM_Code !=@NULL) "A" Case (DSLink47.FACode = "14" OR (DSLink47.FACode="13...

Hi, Kindly Give me some clue how to Configure ODBC driver on SOLARIS. I have .odbc.ini file which has code like this for SQL connection: [SQLDSN] Driver=/export/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMmsss19.so Description=DataDirect SQL Server Wire Protocol Database=Source LogonID=odbc01 ...

I have installed DS version 7.5 standard edition in Solaris. I need to know how to have ODBC Driver in Solaris. Do we have any third party tools to have ODBC drivers for DB version 8, SQL server and LSP and Oracle 8i. When i created a job using DB2 bulk stage and ran it i got a error like this "...