DSXchange

Hello ! Below post may help you..it will return a number then you can divide by 7

[url]viewtopic.php?t=107280&highlight=date+difference[/url]

Thanks

If you use Oracle you can use the 'initcap' function


SQL> SELECT INITCAP('YOU TODAY') AS INIT_CAP FROM Dual;

INIT_CAP
---------
You Today

Hello All ! Just thought of sharing some information. Do we need a separate topic for IBM Information Server? (To discuss issues in Installation, migration, upgrade, and configuration information) some general info - With the version 8 release IBM introduced the Information Server with a new look in...

Thanks a lot Ken!

Wow ! It worked Great !

Thanks again.
-NB

Hi, Any one please help me ! I have a date and time format like '20061003191438' (yyyymmddHHmmss) as input date from source. I want to load this in Oracle date. I have tried with 'DateYearFirstToOraOCIWithTime' but its returnig with some date with charaters like 2016-BC-07... Any suggestion apprecia...

Hi, The sequence looks ok. In check audit table sequence - first increase the batch number for the Src (A or B or C depends on the your source) insert new row with incremented batch number and system date as extract date. Yes, you have to write into table when they triggered. //// The doubt here I h...

Thanks all ! The dimension has around 100,000 rows(in one of the Dim), I tried to use OCI but getting poor performance like 8 rows/sec. It started with 121 rows/sec then it started gradually decreasing the number of rows.. fact is having 1.3 million to load. I will try with hash and check the perfor...

Hi, Hope this might be discussed earlier, when searching I could not get right answer. Situation : Consider a fact table contains 7 dimension and need to lookup all 7 dimensions. While comparing hask lookup and OCI lookup which one will be best choice? and which will give good performance? Which wil...

[quote="kduke"]Q1 has been answered. Q2 use both todays date and the max date in your audit table. Q3 use max date + 1 till today -1 because today is probably not complete. Q4 You need a record in your audit table for each source. Insert this record only after today is done. A lot of peopl...

As Ray mentioned early it might due to the value which can not fit in the datastage data definition. Check the SQL type , Length and Scale.

-NB

This is possible if two different jobs are used, but not at the same time.

Could you explain the situation?

-NB

Hi, You can use BASIC Field function, Field (string, delimiter, instance [ ,number] ) String is your input - 234455 * 82379 in your case delimiter is the character that delimits the substring instance specifies which instance of delimiter terminates the substring. number specifies the number of deli...

Hi, Check the Mail properties like SMTP mail server and From & To mail addresses (some mailserver could not mail thru internet like to your yahoo id). And verify the triggers, you can use triggers for each link or you can use the custom trigger. If you use custom - check how many conditions you ...

Hi, Let me try to answer from my view point to your question. [b]Q1:[/b] you can have the audit table as below Audit_key, Source_name, Process_Batch_number, Batch_Extract_Date, Processed_Row_Qty Initialize the table with Source Names like below 1, SorA, 1, NULL, 0 2, SorB, 1, NULL, 0 3, SorC, 1, NUL...

Please do not make this forum junk ! This is not the first duplicate post from you .

-NB