DSXchange

Hi Anshuman

Well its possible if you are having rough idea about the source metadata. We did it using a Generic stage and Orchestrate operators. Though its a complex way of doing it. It can be done. But from I will suggest you should avoid this Metadata driven approach.

Regards
Ashwin

Hi

Did you change the Data from EBCIDIC to ASCII while FTPing it to Unix box?

Hi, I have a non nullable field in source. But in target this field is non nullable . I want to make it non nullable using modify stage. Currently this is achieved using transformer stage. Also if the value of the field in source is '' then i want to set it to null in target. I could find nullable ...

Are you specifying the schema name with the table name?
Did you check for APT_DBNAME?

Hi I will suggest that you should try avoiding the two transformers. Try implementing all the transformations in one transformer. If at all you can't avoid then I thing directly linking this transformer to next transformer will be better that using a stage between them and then linking it to second ...

You can possibly use

Cron Scheduler
Autosys or
Tivoli Job Scheduler.

Regards
Ashwin

Hi Deepak

We had created an Estimation Tool based on different parameters for Datastage Project Estimation. I can guide you about the parameters, but I am sorry the Tool can't be shared.

Regards
Ashwin

Hi We faced a similar kind of problem while processing data for latin american countries. The solution which we implemented was using a job before we start the processing for converting UTF8 to ASCII and a job at the end before loading the data which converts this ASCII to UTF8 again. This helped us...

In sequential file you can read and write the data only sequentially, whereas if you are using a dataset you can read and write the data, parallely or sequentially. Default mode being Parallel. Datasets don't store the data like a sequential file at the specified physical location. They are normally...

What are the various parameters needed for ETL performance Hi Vikas There are many parameters on which your ETL performance depends. I can list some of them here. The flexibility of the architecture. It shouldn't be tool dependent. Which database engine will be used for the transformations? What ha...

Hi Abhisek

You can manually create the table definition, or load the imported table definition. Please be specific about what exactly you want to know, so that we can help.

Regards
Ashwin

Hi

You can get ppts from Ascential(IBM) for Datastage EE also. Otherwise User Guide is the best option.


Regards
Ashwin

Hi If you are trying to do this in PX then it is not possible. Sequentila file doesn't allow two links, as in one output and one input link. Though it can have a second reject link. Modify your job design and remove those sequential files. Directly funnel the two links. I hope it will solve your pro...

Are you trying to do this in PX or Server?

Hi Prashant As Andrw mentioned there is no specific answer to your question. Though one method which I have been using is taking 5 sample records in source and doing all kind of manipulations on them and checking if its giving the desired output or not. Other methods are using queries in MS access o...