DSXchange

Hello All,

Which is the easiest way to search for a specific job in a project when you have 50 to 80 categories and more than 400 to 500 jobs.

thanks

suggests that the SID you're specifying is not in tnsnames.ora on the machine from which you're trying to connect.

Ray, Thanks for the reply. Can I know where do I find the tnsnames.ora file on the unix machine (DataStage Server). The client machine does have the SID in tnsnames.ora file.

thanks

Hello All, I am not able to view the data for the Oracle9i stage. The error is ORA-12154: TNS:could not resolve service name. I tried on the datastage server and got the same error $ sqlplus username/password@SID SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 4 19:22:24 2005 Copyright (c) 1982,...

Sainath.Srinivasan wrote:Do a reverse sort on the required keys and perform the logic using stage variables.

I am trying to load everything into a Hash File. What kind of sort do I have to perform? and can you please explain how to perform the task with stage variables.

thanks

Hello All, How is it possible to make the previous record zero. Col1 Col2 Min_Date Max_Date Code COunt 123 456 2004-01-01 2004-12-10 30 1 123 456 2004-12-11 2004-12-10 30 1 If current.col1 = prev.col1 and current.col2 = prev.col2 and min_date = max_date + 1 and code = 30 then make previous record 0....

Try to drag three lookup links from your hash file and on each expression editor of hash write x,y and z from your source file.

Hope that works.

Here I am trying to give some ideas and not sure where it solves your problem.

Is your source and Agg have the same sort order? If it is not match the sorting columns and sort the order on both and try see if it works.

Good Luck

I think it is fortunate that both of you guys posted your 665th post to help me. Both the logics worked perfectly well.

Thanks to both of you.
rcil

Hello All, I need some help in completing the below task. The way I tried is not working. Col1 Col2 Col3 Col4 ABC123 903534 0 10 ABC123 903534 0 12 ABC123 903534 1 14 ABC222 903534 1 30 ABC333 12345 0 5 ABC444 222333 0 5 If the col3 = 0 then col4 = 0 and if previous.col1 = current.col1 and previous....

Hello All, Here I am trying to understand a previous built job. what results do I get when I have two output links with different transformations writing to a single hash file with single key? On what situations do we use this kind of logic? If we check only the 'Clear File before writing' and unche...

What is the differece between two single quotes with out a space and @NULL Ex: Amtbilled = '' and Amtbilled = @NULL. Is it mean the two single is to check for a blank ( no space) and the second @NULL is to check for nulls? Hope someone can confirm this. Do we have to check for both all the time or i...

Hello All, Can I create a output file based on the parameters. For example, I want to create two output files from my source in UAT and in production I want to change the parameter in such a way that the second file should not be created. There is no job sequencer involved. It is a single job. I kno...

There is nothing wrong with the metadata. It is same as the source metadata from the database. I made only col3 and col4 as keys in my hash file which are the keys from the database.

Do I have to change the metadata of my last column in which I am going to store the string? Any thoughts?

Simply reference the row and concatentate the incoming values onto the referenced row. I was refrencing the same hash file and writing to it but I was using stage variables. I will try the way suggested but can I know what should be my derivation in my last column where I have to concatenate the st...

Simply reference the row and concatentate the incoming values onto the referenced row. I was refrencing the same hash file and writing to it but I was using stage variables. I will try the way you suggested but can I know what should be my derivation in my last column where I have to concatenate th...