DSXchange

That's where I think my logic is not working. I don't know if I should add one more condition in Reference where clause like : where id=? and ? between eff_date and term_Date and ? between eff_date & term_date because my both srce.columns are checking for the dates to be in between Reference dat...

The SQL statement on the reference link is : Select id,eff_date,Term_date,name from lookup where id=? and ? between eff_date & term_date.

ray.wurlod wrote:OK, three keys, and therefore three comparisons in the lookup SQL.

Please post the SQL statement on the reference link. ...

The columns in both Source & Lookup are: Source : Id, Eff_date, Term_date,name Lookup : Id, eff_date,Term_date,name My requirement is : if Srce.Id =Lookup.Id and Srce.Eff_date & Srce.Term_Date between Lookup. eff_date & term_date then replace srce.name with Lookup.name. Hope this helps! ...

Hi, Can you please be more specific about it. I have 4 columns in Lookup: Id,eff_date,Term_date & name. I made id and both dates as key columns. Thanks.

Sainath.Srinivasan wrote:Create 5 columns from the reference as keys (1 for key, 2 each for the dates).

chulett wrote:Tried changing that "select *" to a specific list of fields? One that exactly matches your columns in the stage? ...

My select statement is :select id,eff_date,term_date, name from lkup where "....."

ray.wurlod wrote:Have you marked id and the date as Key columns on the reference link? ...

Yes, I marked Id, eff_date & term_Date in lookup as key columns.

In UVstage, I made Id,eff_date,term_date as key fields and used user defined SQL : select * from hashfile where id=? and ?between eff_date and term_date. I can view data in UVstage so I know UVstage is set up correctly. I guess I am not using the logic the right way. In Tfmr I wrote the logic : if s...

Hi, I am trying to do the lookup but not getting the correct results. 1) I have source table which has : Id, Eff_date & Term_date, name 2) In lookup stage : Id, eff_date & Term_date,name I am using UVstage for lookup. My requirement is: if Srce.id=Lkup.id and Srce.Eff_date between (Lkup.eff_...

Hi,

Can we use source file for DS job from other server? Let's say my source file is sitting on server 1 and my datastage is on server 2. Can I use source file from server 1?

Thanks.

I started all over again. In designer, in hash file stage, I left the account name blank so it will take current project name by default, then I specify filename and checked create file option, job ran fine. But I can't find the hash file that it created. I went to Manager and checked, can't find th...

[quote="chulett"]How did you 'create a new account' in the Manager? ...[/quote] I went to Manager and open the project that I was running my job into, then created a new table definition(ABC). After this I went to designer and in my hash file I gave that category name and selected my hash ...

Hi, When I try to create a hash file. I am getting this error: Hashed_File_1.DSLink2: DSD.UVOpen Invalid Account name - I created a new account in manager. When I open hash file and I check account option, it shows me the new account that I created. I selected that one and the file name. When I run ...

Can you please elaborate using ODBC stage.

Can we load .dbf files tables using datastage