DSXchange

Hello, I am modifying an laready built code. In one of the jobs, in the constraint there is a condition specifying LinkName..REJECTEDCODE = 0 and IsNull(Field1) <>1 Could someone help me understand the meaning of these two statements. I am facing these typr of statements for the firts time. Thanks i...

Hello, I have Sequenser, that runs Two jobs and Two Sequenser. First one of the jobs run then the sequenser runs and then the second job and finnaly the second sequenser runs. My problem is even if the 1st Sequenser gets aborted due to some reason still the second sequenser runs. Is there any way to...

Thanks Guys. It's really helpful. Any HW/Infrastructure Recommendations you would like to give? Only what I said before: A high speed, dedicated connection between your ETL and Terradata boxes. If you using W2K then make sure you have plenty of RAM. If using new boxes make sure your Intels are hyper...

Thanks Arnd:). It was great. Itried it and it worked perfect. Thanks again bapaju, if you always have 2 digit codes and the numbers you have represent the position in the alphabet then you can use the CHAR(64+{number}) to get the appropriate letter. Since you said your string could be 2, 4 or 6 then...

Hello All,

Has anyone used any FAST LOAD utility using Data Stage. Kindly let me know how do we go about it if we want to do a FAST LOAD instead of MULTILOAD.

Thanks Naveen. Appreciate your suggestion. This is not just limited to these numbers. We need to conver 01 to 26 to all corresponding Alphabates. But trick is the field length can be 2 or 4 or 6. Thanks Hi bapajju, You can use 'If then Elseif then Else' block. Use it in the derivation of the ouput f...

Hello, I have an input string that can have length of 2 or 4 or 6. The values for this stri will look like: 01 1201 120616 we need to convert these values to corresponding Alphabates. So the above string needs to get converted to: A LA LFP Could anyone please help me in this. How can we achieve this...

Thanks ArndW. Thanks for the quick response. I will try it out.

Hello,

We are trying to read a file that has records with variable lengths.For example, one record has 5 Fields, the second record has 7 fields, the third record has 4 fields.

What would be the simplest way to read such a file. Please let me know.

thanks
Amitav

Appreciate your view. But does that mean that if number of columns are high (say 10-15) for lookup then the look up will be very slow? Could you please explain a bit more, like what could be module size for a hash file that uses 15 columns as lookup key. Or it will be very nice of you if you could s...

Yes I have checked the same. I tried to load the data in to a simple sequential file. Still the speed of the jobs was same.

Thanks
Amitav

Thanks a lot Ray. The problem was really not in Link Collector. The problem was in the HASH lookup the Lookup was very slow. Infact Link Collector works very well. Thanks a ton for your suggestion None documented, and no reason why there should be. Rows are buffered (you can increase the buffer size...

Hi All, I am trying to do a lookup through HASH file. I am reading 196000 records and in the hash there are 20000 records. The job runs very slow and the rows/sec comes to 24 rows\second. Can someone help me in getting a proper tunning of this type of job. It wouls be very kind of you. Thanks in adv...

Hi,

Just a quick think. Ur hahs file must be getting created fromat Table. You can write ur Source SQL putting a where clause on this table (the table that is source to HASH)

Hi, Is there any limitation for the number of rows processed by a Link Collector or Link Partitioner stage. What I mean is is there any threshold limit in terms of number of records after which the efficiency of Link Collector and Link Partitioner stage goes down? Kindly let me know. Thanks in advance