DSXchange

Could you put through a Remove Duplicates stage. Sort and partition on The key field (ID). Then Sort by End_Dt Desc then by Start_Date Desc, then select to retain the first record.

I believe that should work.

Why not put the incoming data through a transformer and make a constraint on the flowing data allowing only the data to flow where the contraint =

(field.area_code [1,1]) <> 1 or (field.area_code [1,1]) <> 0

I believe setting the APT_DUMP_SCORE environment variable to true will assist with this.

You could always write that DS or sequential File to a staging table then go from there

I believe it has to be a table where you can implement a where clause in your SQL, that way you can refer to the variable value coming through

I believe using a sparse lookup would work. You just have to select the value you want from the initial table, then lookup to the table you mentioned. select the lookup option to sparse in the DB connection and in the where clause do where col1 = orchestrate.source_column

If I were wanting to delete a group of datasets, could we prefix the group we want with a catch all phrase for the project and then orchadmin rm 'catch all phrase'* ?

Our build for this is still down the road just in design discussions as of now. I will let you know how it goes and if there are any issues.

Thanks

Our admins here would like them deleted at the end of the run for disk space issues is why the issue initially arose.

So we had discussed orchadm rm as a solution but didn't if there was any built in funtionality of datastage that could help in this.

I was wondering if anyone had ever had the issue of having to delete datasets at the end of a sequence run? We created a large sequence for daily runs. At the end of the run we want part of the sequence to delete the datasets created during the sequence as we will just recrate them in the next days ...

I see that people keep referring to the practice test through prometric: http://www-03.ibm.com/certify/tests/sam421.shtml Every time I go to this link it takes me to the IBM site and the only option through the link is the study guide that contains 11 questions. I was wondering if there are any othe...

So there is nothing within the Modify stage you can do to preserve the metadata?

I created a parallel job that is taking data from SQL Server doing some tranformations and such on the data but I am never changing data types. Once it goes into Oracle I can no longer see the Timestamp it is only a date in Oracle SQL Developer. Is this a problem in my job aka DataStage or is there ...

I was wondering how to use the Custom - (Conditional) in a sequencer.
I am pretty new to DataStage and need my job to fail if there is a null found in out CurrentDate column.
Anyone know how I handle this requirement?

Thanks!

I am trying to write a SQL statement into SQL server by using ODBC. I was wondering what kind of format I would write the statement in. Normally Insert into [table] Values [xyz...]. I dont understand how you write that values part since they are coming from the job.