DSXchange

Hi All, I have a ddl file with the metadata of a table in the UNIX box. Need to import this metadata to a sequential file as I only have the metadata but not the tables in the learning box. How do I do that. The file looks like cat abc.ddl TRANSIT SYSIBM DECIMAL 10 0 Yes BRH SYSIBM DECIMAL 3 0 Yes C...

Is it that you are able to see the annotations and not able to edit it.

If you are not able to see the annotations in the jobs then go to
Diagrams->Show Annotations

Hi All,

I have gone through the entire post.

But could anyone clearly specific the routine written to delete the dataset and a command line syntax that I can run.

Thanks in advance...

Hi All, I have a scenerio where I sort and hash partition data on column 1 and column 2 also I would have to rename these columns to col 1 and col 2. The output link then is an input to the join stage which has same partitioning on this link. The other input link to the join would have the same name...

Hi,

In this case check your DataStage Director is it showing the log of the job that you are deleting. If yes, then go to status window of the director. Now trying to delete.

Thanks
Devi

Thanks Ray. Will convert these warnings to info.

When we convert warnings to information in development and then move to test server will the warnings yet been seen as information. The same thing to production if the job is moved there from test server.

Check the nullability on this integer field. If yes then it would give a NULL value

I keep getting these warning when using an aggregate stage which is been used to either count the number of rows or calculate the sum of a column. Warning are: "Aggr_Count_Execution: When checking operator: When binding output interface field "ACTL_PULL_EXEC_Q" to field "ACTL_PUL...

Apart of using a modify stage after this aggregate stage is there a way to do type conversion. I want the output columns to have Integer type.

I keep getting these warning when using an aggregate stage which is been used to either count the number of rows or calculate the sum of a column. Warning are: "Aggr_Count_Execution: When checking operator: When binding output interface field "ACTL_PULL_EXEC_Q" to field "ACTL_PUL...

Hi Prasanna, If the amount of data in the input link is more when compared to reference table than this would be a good option to use a sparse lookup. That is 1:10000 ratio between reference link:input link Else you would have to use a transformer stage or a filter stage after lookup stage to check ...

Yes I have that column in the table DLY_PULL_AGG but it is not one of the condition I am looking at.

As mentioned earlier I had raised a ticket with the ETL Admin here. The query which was used earlier DELETE FROM #$PL_SCHEMA_NAME#.DLY_PULL_AGG WHERE PULL_BTCH_CRTE_D BETWEEN '#JPM_FROM_DATE#' AND '#JPM_TO_DATE#' WITH UR Is now been modified to DELETE FROM #$PL_SCHEMA_NAME#.DLY_PULL_AGG WHERE PULL_B...

Thank you... Have raised a ticket with the ETL Admin here. Hope to get some assistance... Will keep the ticket updated.

Got it... thanks again..