DSXchange

My data stage server occupies more space when ever I run the jobs which results in disk space errors always

why is this happening?


can anyone provide a solution for this situation?

could anyone help me with this error ODBS connected to informix ODBC_Connector_292,0: [IIS-CONN-ODBC-000004] ODBC function "SQLFetch" reported: SQLSTATE = HY000: Native Error Code = 0: Msg = [DataDirect][ODBC Informix Wire Protocol driver]10600 ODBC_Connector_302: [IIS-CONN-ODBC-000004] OD...

I have an input which is exp_dt (expiryDate)

can any one help me with the type conversion for changing the date to string

I see type conversion in transformer but cannot fill the details
DateToString(%date%[%"%yyyy-%mm-%dd"%])

sorry for the incomplete information The ODBC stage is used and the DB is informix the records are around 700000 A query is used to get data from 2 tables and with where condition for two conditions. like the query is select a.name,a.phone,a.fax,b.state from person_info a,address b where a.pid=b.pid...

The job has 2 odbc stages and in one of the odbc stage I used a query which has just 2 conditions using where.
The issue is the job takes 70 minutes to run. Is there any way to increase the performance.I see in the monitor of that job, seems the odbc with the query takes long time.

after creating a new project in the information server
you need to select the information services to work with
I cannot form the connection there to select datastage and quality stage

an error which says attempt to contact dsqs:3128 failed.


that is the name of the server.