DSXchange

No need to avoid the transformer stage as its performance has been greatly increased in 7.x versions. No doubt, modify stage still leads the two, but transformer is faster than filter stage and a few other stages. IBM released this information sometime back. Hi DSGuru Can you share the link where I...

Hi Folks

Is it possible to have Sparse lookup on TeraData Enterprise stage ?
Is there a Workaround

Hey Folks Ran into an implementation that has requirement as follows 2 DataSets to be looked up against each other 2 Conditions a) Reference link is empty Pass all records from Stream link (no look-up) b) Reference is not empty Match records and pass the matched rows How it is implemnted now is usin...

Hi

The OPEN/CLOSE is indeed available , and we used the same in solving the problem. It is available with Load/Append mode in Oracle Enterprise , but is not available for use with UPSERT mode.

Sorry for the confusion !

Hi Folks Is it possible to load data into an oracle table and delete some records based on a certain condition on the same table , and maintain these as a single Unit of work ? You can create userdefined SQL and place inside the After tab page. This will work. There is no before and After Tab in a ...

Hi

When Oracle Enterprise is used as a Target Stage we dont have that option of open/close command..Correct me if iam wrong

Hi Folks

Is it possible to load data into an oracle table and delete some records based on a certain condition on the same table , and maintain these as a single Unit of work ?

hi

The sorting before the remove duplicates is necessary. In your case it is working because the auto partitioning is taking care of the sorting. it is doing an inline sort on the keys based on which it is doing the remove duplicates.

Thanks,
Ram.

Hello Folks The following are the stages in a Job DataSet--------->Sort ---------->RemoveDuplicates------------>DataSet There are 6 keys and 1 value column , I need the lease value column among these 6 keys and unique keys , so the input to the Sort is a HashPartition on the 6 keys and 1 value colum...

Hello All I have a parallel job , the input with a set of 5 Keys and 2 value columns. There is a Parallel Sort Stage and a Remove Duplicate follows. The query is i sort the data on all 5 keys and then on value columns , and i remove duplicates on the first 3 Keys . The expected behavior is to get &q...

It is easy !

sed -e '1d' filepattern* > file.csv

Hi Folks I use file pattern to read a set of .csv files. In each of these files , the first name is column names. I have set the "First row is column names" to true , It works when there is one file with that pattern name and fails when there are many files matching that pattern. Any ways ...

Hello Folks Here is a brief background of the the problem that we have . We have 2 links , an dataset input link that contain some key values and a database that stores a sequence number . The requirement is get the sequence for the first record in the dataset , and for each subsequent row from the ...

Folks thanks for your comments first ! But seems that there is something missing altogether , i tried to parameterise the date passed from a shell script and compare Something like ROWDATEFIELD > #shellScriptDate# This is not working at all ! The where clause does not get a boolean parameter to eval...

Hi Folks I'm passing date in a a preset format to a filter stage from a unix script, this is a constant for a particular day . I am comparing this date with data coming into a Filter . The comparison seems to yield some results that are not consistent . Do i have to use a transformer to compare the ...