Recent content by ritanya

Hi All, We have to implement some conditional lookup's (e.g dat1>=date2) in the job. So, while creating the hash files, we have checked the universe stage compatibility option and We are using the universe stage in the main job to achieve this. But, When we run the job using hash file through...

Thanks a lot J

Hi J, I'm using hash file as a reference table in an attempt to eliminate the null columns from my original input data. Also, i would like to know how hash file handles the null values???? Thanks

Hi All, I'm having null values to most of the columns (apart for key column)and i need to pass through hash file. My question is, how the hash file will react or treat for the null columns? help me. Thanks in advance. Ritanya

Hi, I'm passing default value of single space(" ") for one of the column which is char(1) in the transformer. My database is SQL Server. After the job runs, when i check the length for the field, i'm getting 0 as length whereas i'm supposed to get 1. I assume sql server is simply truncating the...

Hi, I'm new to informatica and got confused with usage of lookup files in informatica. Can anyone please explain me with a small example of lookup stage in informatica. advantages and need for creating lookup file? Is lookup file is similar to Hash file of datastage? What exactly the...

Hi All, Can anyone explain me with a simple example the concept of Datastage Hash File. Why we need a hash file? Can't we do the same with a table? Advantages of using hash file? which one is advantageous..either informatica's lookup stage or datastage's hash file? I went thorugh the help file...