DSXchange

Hi kayarsenal, I cannot understand your recent post. Also, the hash file has only field which is used as key and that will be the ID (0000,0001.....) in your case. The lookup is only on the ID which will act as the key. So please explain what you mean by Above is the input(d same) and I need to have...

Hi kayarsenal, This is an alternate way of getting the output. <Step1> Create a hashfile(HASH_KEY) with a single column Col1 <Step2> Read and write to the same hash file, doing a lookup on the key value in the hashfile with that in the source Design for job: --------------------------HashFile(HASH_K...

Hi arasan, TimestampFromSecondsSince(seconds,timestamp) Function Use the StringToTimestamp(string,"%yyyy%mm%dd%hh%nn") function to convert the string to Timestamp Convert the input B ------(HOUR/SS) into seconds e.g. 1330 = (13*60*60+30) seconds and then use the above function (TimestampFr...

Hi David,

(a) which version of Excel are you using

Microsoft Excel 2003

(b) What did you use as your "reference" for the import? (I'm wondering if there is a character in the value that makes it stumble).

I have entered 1 as the reference number

Hi D, I have been successful in importing the log file created by using your code in the excel Template. But when I am try to process it I am getting an error in the macro saying Runtime Error '1004' Unable to get RowFields Property of the Pivot Table Class When I click Debug it highlights the follo...

Hi Dhiren, I have achieved your requirement using 2 jobs. You can use the Basic Transformer to use the RowProc Transforms. I had taken Input as 51,20010809 50,20010808 50,20010807 50,20010806 50,20010805 49,20010806 49,20010805 47,20010806 47,20010805 First Job: I am just achieving the first conditi...

You can give type 009 in the delimiter textbox

Also, please read the following article http://www.datastagexchange.com/Newslet ... habits.php
for getting acquainted with the good habits for posting in this forum

Hi,

Introduce a dummy column in both the files and use the dummy column as the key

Hope this helps:)

Hi,

Introduce a dummy column in both the files and use the dummy column as the key

Hope this helps:)

Hi,

Pass the rows through an Aggregator Stage sum on the balance and group on the Account Number.

Hope this helps

Hi, In the ODBC stage if we select User Defined Query , we get two input boxes for the SQL Query tab --SQL for Primary Inputs --SQL for Reference Inputs To test the two we made a simple job which looks up against the ODBC stage and wrote the Select SQL in the SQL for Reference Inputs and ran the job...

Hi, If I have understood your question correctly then u need 10.96.4.0 | 10.96.4.255 | 10.96.5.0 | 10.96.5.255 | | | 10.96.255.255 This can easily be done in DataStage Job using Stage Variables Declaring 2 stage Variables Counter1 - Intial Value =4 Counter2 - Intial Value =0 Counter1 Derivation: If ...

Hi snassimr, You can use the Universe Stage for viewing the Hash File On the Stage Tab for the Datasource name fill localuv (which you will get by default) leave the username and password blank In Table Names fill in the name of the Hash File The Hash file needs to be created under the account or if...

Hi All, I need help creating a I-DESCRIPTOR field Existing Metadata in Hash File is Emp_id Emp_name Num I want to create a field whose value is 10 times the Num field above I tried creating this field as follows 1) REVISE DICT HASH_EMPLOYEES USING ENTER.DICT 2) FIELD - VALUE LOCATION - NUM*10 CONV- ...

Hi Friends,

How to get the names of all the columns in DS_JOBOBJECTS i.e How to get the schema or metadata of DS_JOBOBJECTS?

Thanks,