DSXchange

We normally do not create sequences here at my project .
I know it sucks...

Hi All, Based upon the responses I got, following are the possible options for me :- 1) Create a separate job as suggested by Craig. 2) Use No Logging option as suggested by asorrell(It isn't feasible since according to our DBA that will make the table inaccessible if the job aborts during the delet...

@Craig,
Thats the thing I don't want to do.
I have kept that as the last option. I was hoping if I can do something with in the same job

@Craig, I tried to do the same but if I have to dump that small portion of data, I need to create a separate job for it. Cant there be something else ? @Andy Ok, I'll try it but 1 query. DELETE is a reversible process, It'll create transaction logs all the time Or there will not be any difference be...

Yeah Craig, when I said "previous day's data" I meant previous business day's data. Both are same thing.
Everything is to be deleted which of previous day or older.

Hi, I have a requirement where I have to load the data daily in a table after deleting previous day's data based upon the column TRAN_DT(Transaction Date). While deleting the data I have to make sure that I delete only previous day's data only and not today's and future day's data. I have done the s...

Jerome, try fetching whole data from the source and then use a filter stage and give the constraints in it.

If Its DB2 then below query should work

@Priya
Yes, my solution what I have posted above and your solution are giving me the same output so I think the logic is working now.
Can you explain me when you said that we can skip null checks in 8.5 and above ?
How can we do it ?

@Priya I'll try it and let you know whats my result. For the time being I'll tell you what I have done. I have used 1 stage variable svName --> Convert(Convert('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz','',NullToEmpty(DSLink2.NAME)),'',NullToEmpty(DSLink2.NAME)) Then I have used a constr...

@Rakesh,
I know that Qualitystage is better tool for this requirement, but we have a constraint of doing it by Datastage only.

As Ray said, there's no straight forward answer to that. I think it takes atleast 4-5 months to have good knowledge about datastage. Obviously practical knowledge is a must. It also depends upon the grasping power of the person. I have 4 years exp in datastage and I still consider myself in the lear...

Hi All, We have received a requirement from our client where we have to cleanse the Customer Name Field through Datastage. The Name(VARCHAR(120)) should be considered as Invalid and to be reported in the target if 1) It contains only numbers OR 2) It contains only junk values(or special characters) ...

@Sankar,
I dont think that will work, for the 4th record GROUP should have "3".
In your logic the counter thing is missing, so you have to use one more variable for incrementing the counter.