DSXchange

I used sequential file which has the input and other sequential file for the output. Along with these I used webservice transformer. like-------:-seqfile-------->webservtrans--------->seqfile do I need to use XML output also after sequential file input....pls let me know because as of now........I a...

The input to a transformer contains 8 fields ID year sts mbr year1 sts1 year2 sts2 the output should contain only 2 fields. ID year (OR) year1 (OR) year2 ID remains the same and for getting the other one below conditions should be applied if sts--Active then "year" else if mbr--Y then &quo...

Actually the job with out WISD stages also took the same time. Lookup has 2 input links so one is stream and other one is reference. For my particular job stream and reference are both ODBC stages as I could only find sparse in reference ODBC there is no sparse in stream ODBC. I assume that is the r...

actually my job has two lookups, for the first lookup stream------>ODBC and reference--------->ODBC so for reference ODBC I used sparse option. but for the stream ODBC I cannot use sparse. for the second lookup stream------->copy and reference------->ODBC so for reference ODBC I used option sparse. ...

The details are stored in ODBC using sparse lookup stage,There are two different ODBC stages used and they are sparse lookup stages. In one ODBC the details of active entity_id are stored and in other entity_id the details of inactive entity_id are stored. In a situation of my job what happens is lo...

thanks, The target is not a database, it is WISD output stage. the data is not loaded anywhere it is just a response to a request. the request is entity_id and the response is the details of that person. I used two ODBC stages to pull the data for all entity_id's and when the entity_idis given as a ...

The job I designed has WISD input and WISD output stages with lookups,ODBC connectors,Transformers. This is used as a Information provider for a service from information Server console. When I deploy the service the see the job in the director always running but unless all the records are completed,...

I used sparse lookup everything seems to be fine.

but Why is it taking too long to deploy completely?

I monitored the job in the director and it tool around 60 min to get deployed completely.

can you please let me know what is the cause of that?

The information server is in the unix server. Due to some network problems in the server,the server was rebooted. Is there any way to find out whether the information server is back up again in the unix server or not? I mean to say when the server is up again how can I find out whether all the infor...

In the ODBC stage use sparse lookup option and is that the only change I have to do?

thanks, I see the condition sparse lookup only in ODBC,Is there any other way to use sparse lookup I mean change settings in look up stage. As I am using the general lookup the data is stored in the memory,so I need to disable and enable the service when ever the data is loaded. If I use sparse look...

Hello, I designed a webservice by invoking a job from datastage in Information services director.The job contains 3 ODBC stages connected to the database. My issue is when ever the data is updated in database I need to redeploy the service? I see a strange issue in the service,After data is loaded o...

How do I change the configuration file?

I mean to say how to move its path?

Yes,I use lookup stages in my jobs and I get this error only at these stages. After deleting some of the files in the server I get space and they run again with no errors,but later I get the same error. The volume of data is around 1.5 million records.My jobs have lookup's used for databases and cop...

Error writing table file opt/IBM/InformationServer/Server: No space left on device

this is the error which I see always