DSXchange

vivekgadwal

@INROWNUM or @OUTROWNUM was the one that worked for me Can you please let me know how did you do that? Do you have the value of the Job parameter to mean the last line number which is supplied by the user or extracted from the table by any other job? I believe that by using @INROWNUM, he is trying ...

vivekgadwal

dstage443 wrote: is there any function/macro that will tell me how many rows were sent over from transformer to link1

Try looking up DSGetLinkInfo()...!

vivekgadwal

ray.wurlod wrote:Not in a parallel job (unless in a BASIC Transformer stage).

My bad...I haven't seen the "Parallel Job" note here!

vivekgadwal

Harshagks wrote: Conversion Rate = 1.234564
Amount = 56
TOTAL AMOUNT = 69.135584 but after the ROUND operator the value
sholud be 69.1356.

Try this:

Code: Select all

 FMT(Arg1*Arg2, "R4")

vivekgadwal

Even with pure inner join, the merge stage is still slow. One reason why I didn't put it into a hashed file for lookup is the huge number of records at about 2.4 million. Am not sure if this is a good idea of doing a lookup from a hashed file instead of the merge stage. Well...as long is the size o...

vivekgadwal

sachin1 wrote:change the datatype for timestamp column to varchar it will work.

Remove the delimiters and spaces between the timestamps (using "Field" fn.) and then pass them into aggregator stage. (Ex: '2008-05-26 00:00:00' should be represented as '20080526000000').

vivekgadwal

both files are about the same size ~2.4million. Would pure inner join be much much faster? thks. Tell me this...is there some other processing that is being performed in Job 2...like sorting etc.? If not, I do not know why one job with merge logic is running faster than its twin (at least with same...

vivekgadwal

One job does about 20k rows/sec but another is only doing 100 rows/sec job 1 merges file A and file B job 2 merges file C and sequential file from job 1 (output of job 1) The diffence between the 2 jobs are the mapping keys File A.keycol - varchar2(144) display 0 File B.keycol - varchar2(15) displa...

vivekgadwal

The easiest and safest way to do this is to do a full project export, create a new project and then do a full project import into the new one. This indeed is the only way. But , be mindful that if at all you have environmental variables in the original project, they would not be copied over to the ...

vivekgadwal

Jessie, If the format of the date is not an issue, then you can achieve this by using the macro DSJobStartDate . This can be used right where you provide the name for the file (inside the Seq File stage). EX: ...Path.../DummyFile_#DSJobStartDate#.csv would generate a file in the path named DummyFile...

vivekgadwal

Can i know how do i can implement in datastage 7.5x2 version. Please help here Rajesh, We sure can help, but it would help if you can go through the link that AmeyJoshi has sent. It would also help if you can post the issue you are facing. There are several ways to tackle the SCD problem as I, and ...

vivekgadwal

ray.wurlod wrote:It's a bad day when you don't learn anything!

I know and I haven't come across this Type 4 anywhere...so may be i have to keep an eye on it! :D

Thanks for the reply...

vivekgadwal

ray.wurlod wrote:Type 4 : Like Type 2, but the history is maintained in a separate table.

Ray,

I didn't know that there is a Type 4 SCD. Is this adopted often in companies? So far, I have been doing Type 2 with an Active Flag to denote which is the most recent record!

Thanks,

vivekgadwal

Jessie wrote: After merge- the file should looks like

Col1 col2 col3 col4, clo5, col6
Key1 key2 22 33 44 55
keya keyb 12 23
keyc keyd 45 54

Ok... Did you try the way I suggested? Did it work? Let me know.

vivekgadwal

the out put file from 'merge, has file1.key, file2.key how do I join them to make it one row? thanks Jessie, The way you join is, say, File1.Key and File2.Key need to be joined, in the Outputs page, under Mapping tab, you drag and drop the same in the specified areas where it says " Drag From ...

DSXchange

Search found 452 matches

Re: reading file validations and log file

Re: Using of ROUND function

Re: slow performance while merging 2 files in merge stage

Re: slow performance while merging 2 files in merge stage