DSXchange

Look in the job log to verify that the SQL statement that you think is being execute is, indeed, the one that is being executed. Sometimes they get changed in minor ways. ... Checked in the log view ..of that jobs everything is perfect. Do you want me to change the array size. ?? You want me to cha...

Hi ,

Ran the same query from TOAD. Its displaying the records .

Please help me in this....

Hi ,

We are running the job from Autosys :

Job took almost 6hr 30 minis to complete.

Sequence , and the Jobs finished successfully but Autosys Job is aborted.

log is genereted as : dataStage job failed with return code : 269

Please Advice on this.


Thanks,
John

Hi Muir,

Data is there !!

Good Question !!

Hi , I'm using Oracle connector stage for the first time. Have totally 19 columns in the Table definiton Out those 1 column length is 16383 of Data type LongNVarChar I'm running the jobs in Dev and IT..its running fine. giving the count. It seems Dev and IT data is not the correct data. If i run the...

Below is the scenario which i want to achieve by means of the Sequencer. Sequencer calls the job that basically extracts the data from the table from certain period of time. For example, when the job is run for the first time given a parameter of start date (eg., 2005/01/01) till current date.(ie.,2...

No, it would be a much better learning experience if you manage this on your own... with some guidance, of course. :wink: :wink: First order of business would be to capture or store the information you need to send, say like a flat file or the USERSTATUS area of a job. Have you done that? I have do...

Thanks for your inputs !!

It would be better if you provide the code for routine !!

How can I get these 3 columns (Source_count, Min_limit and Max_Limit) data into a mail notifications.

Please advise

Thanks,

John

Would you please help me to create a routine ............

Pls send me the code for creating routine....to invoke DSSendMail()

Looking for your kind help in this

Thanks,

John

Hi All, Here My ETL Design is somthing like this. Source_Tbl, Limit_Tbl, Transformer ----frm Transforer to Seq_file Source_Tble ----------------------- I will get the Source, Limit_Tbl ---- have Min_Limit, and Max_Limit for the Source I want to get an email these details : Source_Count, Min_Limit an...

Hi,

How to create the routine for this function not to allow the special characters.

Function :

Convert(Convert('ABCDEFGHIJKLMNOPQRSTUVWXZY0123456789','',YourField),'',YourField)

What could be the Code to create the routine for this function ??

Thanks,
John

Thanks for your kind reply ...............the above given example will workout as I hope .......let me try this....

I mean Only Alpha and Numerics should get loaded in the staging table...........

Thanks,

John

This modifcation should be eleminate all the special characters.........That how ETL should be..

Please help me in this.....

Thanks ...a lot......

John

ETL designed to move the source data to staging table, Here source is Oracle table and Staging is also a Oracle table In the source data one of the column's data is comming like this..... APRN MS, D.Ph NP#12391 MS, RD, LD, CDE AO3143 phd g \\\\\\\\\\ RN/CDE nhnnn b v CPHT RN,BSN,CDE ` FACP,FRCP-C,FA...

Your data does not have an hour (or time) part. What are the target datatypes and how they are mapped ? Also what is the target insert SQL ? ************************************************************* You mean that data has no time specified ?? if the data is same how can I load the data ??? Targ...