Thanks a lot!! will try this approach.

I have a requirement where i have to join 2 tables as per following conditions:- 1)inner Join on 3 keys (acctno1,acctno2,acctno3) from table1 with table2 2)for the unmatched records from step1 join the 2 tables on only 2 keys (acctno1,acctno2) 3)for the unmatched records from step2 join the 2 tables...

We are planning to go 4 node config file for Datastage.

Yes juniorfoo, i need help in writing the parser for ebcdic files. Can you throw some light on how to write it?

So, how is the performance while loading data through oDBC stage to vertica?

Does COPY command supports loading of data from EBCDIC format compressed files from Mainframes directly to vertica tables? If yes, please let me know how we can achieve that.

Hi, we are using Datastage as an ETL tool and vertica as our target database. Wanted to know if anyone has tried connecting to vertica through Datastage using ODBC connection.