DSXchange

I have data like:

ID Flag
1 Y
1 N
1 Y
2 Y
2 Y
2 N
2 N
3 N
3 Y

The output I want is:

ID Flag
1 Y
2 Y
3 Y

That is across each id it would check for flag and if this is 'Y' against any occurence, It would give Y a final output with one occurence of ID.

I guess it should take everything from source + extra columns from metadata.

People, please correct me if I am wrong.

Thanks to all of you.

Ray,

Though I couldn't read your previous messae completely as some content was hidden but thanks for the great help you have been giving me on my posts.

thanks Ray and Craig. Please give me some more hint like how can I do it....

Thanks Craig.... I got it....

Vinoth, I didn't want to write 15 years equivalent dates so.... anywez got the solution now. Thanks.

Thats what exactly I am looking for.... with which work around I can implement it

Thanks

can u pls be more specific?

Hi All, I want to implement Calendar Dimension table using transformer. My requirement is to create load this table with all the dates from 2000 to 2015, day of week, month, quarter etc. I can easily get last three values using functions but how do I populate the table with all the dates in this 15 ...

Thanks priya...
but it means thr is no direct implementation of switch/case available in transformer?

How do we implement FOR or DO looping in transformer?

How do we implement Switch/Case statement in transformer?

are the keys for lookup1 and lookup2 are same?

when you say in the end data don't match, what exactly u mean? do u mean to say you are getting data which you shouldn't or you are not getting those records which should have come into ouput?

Would be good if you can give some data example here

Source is a db2 table. Processing involves some simple transformations. No, I am not keeping track of how many records have been processed and I don't know even how can this be done. So just wanted to know is there any way in data stage where in it can identify the last successfully processed record...

Hi,

I have a job which aborts after processing 1000 records. The input file has total of 10,000 records. How do I make sure that when the job runs next time, it doesn't process the already successfully processed records and starts from 1001th reord?