DSXchange

Thanks much ray

Thanks ray.

If we use MYSQL in datastage server edition then can i use the ODBC Enterprise stage ?Also can you please give me some more information on correct ODBC character?It would be great if you give me a small example.Thanks in advance.

Regards,
Pavan

hi

Which stage do we use to access MYSQL database in datastage parallel edition(7.5)?.
Also are there any restrictions in using MYSQL database in datastage?Thanks in advance.

Regards,
Pavan

[quote="Sainath.Srinivasan"]You can use Oracle Enterprise stage.[/quote]


Can you please let me know how i can do it using oracle enterprise stage?please give me brief steps to implement the same. Thanks

Hi

How do i call a oracle function in datastage 8.1 version. I have a mod 11 function in oracle which i need to call in my job. please let me know how i can call a oracle function and with which stage i can call it? Thanks in advance.

Regards,
Pavan

Hi

i have data in the sequential file with signed numeric data type in 4 out of 20 columns. Could you please let me know the correct data type which i have to declare in the sequential file stage for those columns with signed numeric data.Thanks in advance

Regards,
Pavan

Hi I have a file which has information spiltted into 3 parts. 1. Header 2. Details 3. Trailer Below is the sample data which i have to load. 97 DSS5320 010209 0169000104584400407079670460000012807550000000000 844 0169000237584400361566050460000002044570000000000 844 016900023858440036156605046000004...

Hi! I am reading a XML file thru an XML input stage and loading into oracle table.The size of the xml file is 85 MB.The job is running continoulsy for more than 120 minutes. Could you please help me in reducing the runtime of the job.If any performance related measures need to be taken in the job? T...

Hi Sana, Please try this in the description of the xml input stage After the Xpath in the description, include- /text() i.e Xpath/text() Cheers, Pavan I cannot parse xml files of below format using xml input stage.Job is running fine and no output written to the file.I have included namespace declar...

Hi All, I need to run the jobs in multiple times,I designed the Job sequence for a particular job and added Start & End loop activity between the Job activity..It's working fine. now i would like to know ;in runtime...how we can pass the START LOOP Activity 'FROM' & 'To' value.while running ...

hi!

I would like to take the certification for IBM Data Stage server edition.

Please let me know whom should i contact and other required details.

Thanks in advance.

Thanks,
Pavan

hi,

Is there any migration tool thru which we can shift all the jobs and project as a whole from informatica 7X to DataStage 7X.

If not possible,pls let me know if there are any other alternatives.

Thanks in advance.

hi One of our client wants to shift to DataStage from Informatica.Is there any specific process thru which we can do it? I have some queries regarding the same. 1.Is it possible to change the current mappings in informatica 7X to DataStage 7X ? 2.Is there any process thru which we can export and imp...

What is difference between inter process and intra process stages?Thanks in advance.

sort the data in unix and then try loadin in datastage.It should work as 20 million records are minimal when u sort data in unix