DSXchange

You can use DS.TOOLS from the DS Administrator for releasing the Locks.

Or you can make the source table as the primary input and target table as the lookup. This should also work well with the same update strategy.

Love, The problem with this approach is, The Source will be time related. Say i am maintaing records only for a year in Source and Our DWH table will contain History records. In this case, the mentioed approach will fail. In that case select only those rows from the target which fall in the current...

Source_Table | | | V Target_Table----->SeqFile----->Trans------>Target_Table Your update action should be Delete existing rows only . Pass only the rows which are not matching. Hope this will help you.

Are you writing the result directly from the transformer to the target(may be seq file,Hashed file or db table)? Is there any other stage in between the target and the transformer? What is the data type in your target and what the data type you are using in the map?

Have you provided anything into the table names field of the stage? It requires this, i think Ray answered about it, stating it uses the table name to validate the columns in your design when the connection to the database is established but before the request to prepare the SQL is issued. Check thi...

sekr wrote:its not working ! i had tried ..

Can you paste the what error message you are getting when you are doing it from sqlplus.

Yes for every job, a corresponding log file RT_LOGjobno file is created(where jobno is the unique identifier of job), it resides within the project directory (in windows)(and I think the same sholud be true with UNIX also).

Thanks chulett for correcting me. This post describes it the best http://www.dsxchange.com/viewtopic.php?t=89802&highlight=64+bit+files For that you would need to make change to uvconfig file setting 1 as the value for the parameter 64BIT_FILES(for new file created only(not existing ones)). No, ...

If you really want to go beyond the 2GB size, then you would need to create the Hashed files as 64 bit files(otherwise it is only 32 bits). Do a search on 64 bit hashed files, you will find lots of post about how it can be done. For that you would need to make change to uvconfig file setting 1 as th...

yaminids wrote:Hello there,

I think you cannot use the Hash file stage if the source has many records.

Hey,
Can you just share with us, wht was the problem with large number of records? How many records you are talking about? What Size of the Hashed file?

As you have said that parameter is the way to go about it. All tables should have a timestamp field. At the end of each run to the job, the max timestamp of the target table is written to a Hashed File with a known key value. In the next run (of the sequencer) the same Hashed File is read from a rou...

rkdatastage wrote:Hi
It is utilized inline during an expression, as opposed to CALLed

RK

You mean when we use a function within an expression it acts as inline?
I doubt

The quickest way is probably to use a hashed file. Create 2 columns. Hard-code the first column with a value such as 'X' and make this the key column in your hashed file. Set the derivation for the other column in your transformer to @OUTROWNUM. As the rows pass through the hashed file they will be...

I think you are taking the columns from Hashed Files (the lookup) to the reject link. Since this is the place where the lookup is failing, meaning no row can be found from Hashed File for the lookup keys, that's why it can not provide any value to the reject link(meaning Null). Solution: Do not take...