DSXchange

Thanks a lot Mike. It worked.

Regards,
-Sumit

Hi Yamini, The <> does not work with Null values. You need to do null handling to solve this. Follow this approach: Declare seven staging variables say ColA, ColB, ColC, UniqueCnt, ColAvar, ColBVar and ColCVar in the same order. Initialize all the stagevariables to 0. Map ColAvar and ColA to If IsNu...

Hi, I have a job in which I use system variable @INROWNUM. It is a simple job with two transformers. In the first transformer I make a lookup to a hash file which is right now empty and hence does not return any records. The @INROWNUM is not behaving as expected. It starts with 2 instead of 1 and wh...

Thanks a lot Ray and dsxuserrio.

-Sumit

Thanks Ray. That explains why it takes time but I am still curious to know what happens to the log file if we rename a job.
Does it also get deleted or does it continue to exist on the system and we just lose the pointer to it by renaming the job?

Regards,
-Sumit

Is the number of record types fixed. In other words there are maximum four record types 10,20,21,40.

-Sumit

Hi, I have a job that when ran gave a lot of warning messages. I am trying to see the log in director but its not opening up because its huge. I tried clearing the log from the director but even the clear log window seems to taking forever to open. Now I am planning to change the job name to get rid...

You are right Arvind but we have no informaion on
1) the frequency of load
2) if the source file contains new set of data everytime or not

Regards,
-Sumit

Addition to the previous reply.

Using the same logic you can define a flag. Use this flag to push the values to Table B only when a new combination comes.

Push all the records to Table A

Use the value of UniqueCnt in both TableA and Table B

Well since the data is sorted that solves the problem. Declare four staging variables say UniqueCnt, ColAvar, ColBVar and ColCVar in the same order. Initialize all the stagevariables to 0. Map ColAvar, ColBVar and ColCVar to ColA, ColB and ColC from the source. In the derivation of UniqueCnt have th...

Is the data coming from the source file sorted by the three columns that define uniqueness of a row? Could you also please give approx number of records you expect to process using this job.

Regards,
-Sumit

Thanks to all for your replies. I was expecting it to be an OS side issue.

Thanks again
-Sumit

Hi, I have a job that loads data into a sequential file. The jobs takes close to 30 minutes to finish. If I try to view the data in the sequential file from DataStage designer when the job is running I was able to see the records in the file until a few days ago. But I have noticed that from past fe...

If you load Oracle data into hash file and do a join in transformer stage then in case of multiple matches found the hash file will return the last match only. In case you want all the rows to be returned use the ODBC stage. In the transformer properties > Input tab select the "Reference link w...

I wanted to aviod writing any code but looks like I will have to do it. Thanks for you ideas.

Regards,
-Sumit