DSXchange

HI I am having a column known as PERIODNAME and it is having the following values: JAN-06 FEB-06 : : DEC-06 ADJ-06 Now I need to split this column into PERIOD(JAN-1,FEB-2.....ADJ-13) and YEAR(2006) SO by using ICOnv and OCONV Iconv(src_in.PERIOD_NAME,"D MY") Oconv(StageVar,"D M")...

I am having a table with three columns as follows FIRST TABLE col1,col2, col3(dd/mm/yyyy) 1 abc 1/1/2007 1 def 2/1/2007 2 ghi 1/1/2007 2 3/1/2007 3 jkl 1/1/2007 3 mno 4/1/2007 There is one more table(BASE TABLE) which is having as follows: col1, col2,col3,col4,col5........ 1 2 3 Col1 has (1,2,3) Now...

So its better to drop all indexes except Unique Index as this will help in removing duplicates..

You are correct and hence its taking a lot of time. Also it forces your array size to be set to 1 and thats another downfall. So is it better to use only Insert New Rows only..in Update Action Moreover downt he line we will be doing incremental load for every two days..Even then using Inser and Upd...

Hi DSGuru

I am unable to get what you are saying..My source is coming form Oracle table and not file. Plz elaborate a little more

My Incremental load is for only 1 million records..But i think it is doing full table scan as My update action is "Insert New or Update Existing"

Hi DSGuru

There is no key generation process here.. If I split Insert and Update, I will be needing Lookup right!...Then a full scan of 35 million records will take more time..(I think)

Correct me if I am worng

There were no warnings. I am working on Oracle Database.(Source and Target).. there are no referential conditions By the way this job is runing in development. It is not yet moved to production. Hopefully it should take less time in PRD... Correct me if I am wrong and let me know if this performance...

Hi I am having a job which loads a table. For initial load there were around 35 million records. I loaded them and it tooka round 9 hours. Like this I am having 7 tables NOw I am doing an incremental load for three months and it is taking more time than the initial load. My option int he target DRS ...

You cannot get any out parameters if you c=use stored procedure in before/after tab of DRS.

The best option would be to use a STP stage, call the procedure there and then run the job.

Youc an create a sequence:

STP job Activity----->Main JOB

Hi

I think this would help you
"Database vendor. The type of relational database. With this release, the
option is Oracle. The default is empty, allowing you to identify the relational
database type at run time using a job parameter. Database vendor is
required."

Hi Craig

I did not fully understand your statement. Plz can you elaborate a little bit more

Hi


Thanks all for your ideas..

The file name will be same..

What is traceroute <server name> ?
Is this something related to checking the connection of database.
Could anyone explain little more

Hi I am having a requirement as follows: I need to kick off my job after getting notification that the production box is refreshed. They are refreshing it daily at some instant. After refreshing ti they create a file(touch) with the timestamp of completion of refresh. I also need to check whether th...

Hi

I am runing a master sequence. I would like to capture the start time of the job and End time of the job in a file or table.

How to accomplish this?