DSXchange

Pno and Mat does not give you a unique return result from the lookup. Did you enable multi-row return from the lookup? Otherwise, to get a unique result, include SDate as a lookup key, since this is ... Hi Ray, Thanks for quick responce.I tried with Multi row option in ODBC and I have used Sdate as...

Hi All, We have a requirement that related with Range lookup.We have data as given below,.. Source table PNo ----SDate------Edate -----Mat 111 12/05/2008 12/06/2008 ABC 111 12/06/2008 12/07/2008 ABC 111 12/07/2008 12/08/2008 ABC 111 12/08/2008 12/09/2008 ABC 111 12/09/2008 12/10/2008 ABC 111 12/10/2...

Hi

The Error comes when u are trying to write into a sequential file. Make sure that all the settings are proper.

Hi

Can you paste the error message, it would be use ful to give a solution for your query..

As normal way to import metadata..just follow shivajid2k
steps.

Thanks DSguru2B

Thanks for ur reply...
I solved the problem by using Hash File and UNIVESRSE stage..

You dont have a sort stage :shock: ? You might not be able to see it in the stages pallete but if you go via the repository, you will see that the sort stage exists. If its truely missing then contact your support provider to get it. Hi DSguru2B we dont have SORT stage , i have searched thru Reposi...

Hi All Is there any function to sort the data in server jobs( Not UNIX commonds) My requirement is to capture the duplicated data from source file my source is CSV file, I dont have SORT Stage in our project.If we have SORT Stage , we can sort the data and capture the duplicate by comparing current ...

U can use 'After SQL' in the target stage..That is enough for this situation

Hi Scorpion 1)This is the error which occurs if you have unwanted columns in reference link . 2) or If you mapped the ZZZ column in previous stages (before lookup) and you are trying to map the ZZZ column once again in an other stage(lookup or join) , such cases it gives this error. Remove the unwan...

Hi Kris here I am giving data once again.. Source data. itemno,start_date,volume 1,2007-02-05,120 2,2007-02-06,130 reference link data seqno,start_date 1,2007-02-05 2,2007-02-06 3,2007-02-07 4,2007-02-08 Target data should be ... 1,2007-02-05,120 2,2007-02-06,130 3,2007-02-07,NULL 4,2007-02-08,NULL ...

Hi All Thanks all in Advance Can you please help in resolving below situation... I have date like this in main link seqno,date 1,2007-05-01 2,2007-05-02 data in reference link seqno,date 1,2007-05-01 2,2007-05-02 3,2007-05-03 4,2007-05-04 we need to append the last two rows of data from the referenc...

All, In my job in the source we have a Folder stage then some transformers to velidate Source file data and then target folder stage.My job is not able to read file of size more than 65 MB.Is there any limitation of the Folder stage with maximum file size it can read or Write. In my job when ever f...