DSXchange

I have few records like this 11, A,B,C 11,A,B,C 10,A,B,C 10,A,B,C 9,A,B,C suppose the first column is ID. i need all the records which has the maximum id for the combination of 2nd,3rd and 4th column. My output should be 11,A,B,C 11,A,B,C how do it do it? Please help. Its urgent Use copy stage and ...

Hi Craig,

I think this is much better option, thanks for quick responce.

Thnaks & Regards
Sas

Hi Ray,

My Requirment is

- If file is found then I have to move further and populate staging table.

- If file is not found then I have abort the job and I have to send a mail saying that required file is not there.

how can i do that?.

Thnaks & Regards
Sas

Hi All, I have a senario, - I have to check one folder for given file name(Ex:emp.txt), if file exists then ok else i want to abort the job. - I am using folder stage to verify whether files is exists or not - I don't know how to abort the job if file is not found. :? please help me out. Thanks for ...

Hi All, I have a requirement like I have to set the variable based on output of the some logic, how to do this? In Detail: I have a table, from that table I have to fetch the value of one column based on date and state, I have to store this value in one variable which I will use further in my jobs. ...

Hi, We are working on Datastage7.5.1. We have a senario where we have to get the values for parameters from a table. InDetail: We have to parameterize the Sourcefile FolderPath, path is stored in one table(tablename :parameters column:Sourcefilepath). How can we do this? Please help us out. Thanks f...

Hi All,


For one of my requirment we have MySQL as source, i am trying to import metadata using "ODBC Table Definitions", but i am facing problem with this.

Is there any other way to do it?, If yes please let me know.

Thanks for reply

Thanks to all

Hi,
how to import "metadata" from MySql?

thanks & Regards

Hi,

We are trying to import Mainframe(.CPPfile)file into Datastage, how to do that? is there any pirticular stage to do this.


Thanks & Regards

Sas

Hi All, I am new to Administrator tasks, here I have an issue that I have installed Server in one machine and I installed Client on 4 Machines. Now I want to give the Permissions to the all other 3 users to access the server, How can I give permissions to other 3? And I want to restrict some permiss...

This is not a valid post..

please ignore / delete.

Thanks