DSXchange

Thanks for the help Ray, but since I'm not a premium member, I'm not able to view your message fully.
But I've also tried using the same approach, but I'm not able figure out how to loop through the skipped numbers and retrieve their values.

Regards.

I have a source column with integer sequence, but the numbers are discontinuous.
Like 2, 4, 5, 6, 8, 25...... and so on.
There is no record count restriction, and I need only those numbers which are missing in the aource sequence as output.
like 1, 3, 7, 9, 10, 11, 12......

Please help.

Regards.

I need to read a flat file with multiple record types and load data corresponding to each record type in separate oracle tables. I'm yet to use CFF stage but I've learnt from many sources that CFF's do read files with multiple record schema. The most challenging aspect of this job(to me) is that the...

I'm not a premium member, and I'm not able to view Ray's posts.
Anyways, thanks to all of you for your time and suggestions.

Warm Regards.

ray.wurlod wrote:You are relying on out-of-date knowledge. ...

I'm afraid to admit that its true to some sense. But if there are not more than 1K rows in the input, should I be trying something as time consuming as a transformer?

Please advise.

Regards.

What I'm trying to do is: Seq file2 | | Aggregator(record count, group by Field1) | | Seq file1-----Join-----------------Column Generator Stage--------------------------Taget Dataset (column to generate=F2, column method=Explicit) In the Mapping tab of the column generator stage, add the following a...

AshishDevassy wrote:Is there a reason that you dont wish to use transformer ?

I intend not to load the job, when the same can be achieved by other lightweight stages like column generator and/or modify stages.

Regards.

Thanks Ray, but I was not able to view you full post as it's Premium Content .
However, I will try and change the design to extent I was able to see in your post.

Regards,
Kumarjit.

If you had checked the last few lines of my post, you might remember that I'm trying to achieve this goal WITHOUT USING TRANFORMER/SORT STAGES.....

Anywayz, thanks for your feed.

Regards.

Hello All. I've a source text file with data like below: Field1 A A B C C D With this data, I have to generate a temporary dataset , as below: Field1 Field2 A Y A Y B N C Y C Y D N Field2 is populated based on the following logic: 1.If the corresponding Field1 value has duplicates, the Y 2. Else N T...

Hello all. I might be asking the same question as it has already been discussed a multiple times, but I did not find a proper answer. I'm using a Datastage parallel job to load for a siebel identity S_COMMENTS, but one of its field , COMMENT is a free flowing text field that can have end of line cha...

qt_ky wrote:Try using the User Variables stage.

Could you please clarify how the User Variable stage caters?

Regards,
Kumarjit.

Correct me if I'm wrong Ray. If today is March 31st, 2015, i.e., the last day of the current month,then: @DATE=03/31/2015 @DAY=31 Now @DATE+1 will return me 04/01/2015 as its is similar to adding days to a date, but shouldn't the expression @DAY+1 return me 32 instead of 1, as I'm simply adding 1 to...

I'm still peeking on the options available to get done with issue.
My bad to keep this post in the WORKAROUND status. Will try your's way(using routine) and the one Ray pointed out( @DAY=@DAY+1).

Till then, its UNRESOLVED to me!!

Will keep you posted.

Regards,
Kumarjit.

@Craig: I'm trying to use a Nested Condition stage and set up a Custom Trigger expression which checks whether the @DAY is equal to the last day of the current month. But the challenge here is I'm not being able to use any Datastage System variable like @DAY or @MONTH or @DATE to get the last day of...