DSXchange

Hi All,

thanks for the suggestions. it is working now.

Regards
Pa

[quote="DSguru2B"]Make sure they are varchars or true numericals.[/quote]

The data type for field A is varchar and for field B is char.

i converted field B to varchar before the data enters into transformer.

regards
Pa

[quote="ray.wurlod"]Can you give us an example of a "false positive" - that is, an instance where DataStage said they were equal and you say they're not? ...[/quote]

it is actually Trim(DSLink1.A) = Trim(DSLink1.B)

thanks
pa

Hi Al, I have 2 Fields A and B . both of them are "varchar". I am using a transformer and I have a constraint . this is how I wrote the constraint; Trim(DSLink.A) = Trim(DSLink.B) I am expecting only those rows which satisfy that above constraint in the output. how i am finding all the row...

can you please tell me why should I Run the reject links from each of them through a Funnel stage to accumulate the rejected rows.

Hi All, I have 2 input streams coming into my job. Both of them have different meta data. File1 has the following meta data: (All the 6 fields are integers) col1 col2 col3 col4 col5 col6 File2 has the following meta data: ( both the fields are integers ) ABC TXT now i have to perform a look up ( or ...

Hi, i have a sort stage in my DS job.my input file has file size of 2TB. can anyone please suggest me if i can use sort stage to sort my input data. What about the performance of the job and memory issues if I use sort stage to sort such a huge file based on a key column. Any suggestions; Regards MArk

[quote="kwwilliams"]If there is a funnel stage in 7.0.1 you could combine the two records together and then sort them by the date descending. Put them into a transformer with a contraint @OUTROWNUM = 1. That should work, but I have 7.5.1 not 7.0.1[/quote] Thanks a lot for all your suggesti...

[quote="kwwilliams"]If there is a funnel stage in 7.0.1 you could combine the two records together and then sort them by the date descending. Put them into a transformer with a contraint @OUTROWNUM = 1. That should work, but I have 7.5.1 not 7.0.1[/quote] Thanks. actually i am using 7.5.2....

[quote="Maveric"]Create a dummy key colomn for both the input links and do a lookup on the dummy key column. the output is one rec with 6 fields. the comparision can be done in a transformer.[/quote] after reading the input files A and B. I created a dummy column in each of the inputs and ...

[quote="us1aslam1us"]Which records should be compared? For example the first record of file A should be compared to first of file B or second one or any other? You need to analyze that first. Do you have any of those three fields as Key Column?[/quote] There will be only 1 record in the in...

Hi All, I have 2 inputs say A and B. Both of them have the same metadata.i.e col1, col2, col3 and start_date. start_date has a datatype:timestamp such as 3/01/2007 00:00:00 I have to read both the inputs and then compare start_date from A and B and whatever input has the greatest start_date I have t...

Hi All, I have a oracle stage. it has to do insert records into the table. for i in 1..number of levels loop do the insert into the table end loop, note: the number of levels is parameter which will be passed at run time. eg : if the number of levels is 3 then records will inserted into the table 3 ...

Hi All, I have a question. I am working on Datastage 7.5.1 server edition. suppose I have to extract from DB2 using server edition. and i do i have to load into DB2 . 1) what are the things i do have to keep in mind while doing the extracting and loading using datastage server edition if the source ...

Hi All, I have a question. I am working on Datastage 7.5.1 parallel extender. suppose I have to extract from DB2 using parallel extender. and i do i have to load into DB2 . 1) what are the things i do have to keep in mind while doing the extracting and loading using datastage parallel extender if th...