DSXchange

Yes. It is one of the complexities that could arise while implementing SCD Type 2. If two records with the same primary key combination is coming in the same input stream then we need to split it into two streams, one for insert and the other for update with the update happening after insertion.

Arndw, I have not worked on Server edition. But since this topic was in PX forum and as this feature is not in PX I had mentioned it. I was not trying to do any comparision but just wanted to point out the feature in its counterpart. Also I had mentioned a solution to achieve in PX if I am not wrong.

Hi, Your issue is something similar to Dynamic lookup cache option available in Informatica where the cache file automatically gets updated during the execution but I doubt if we have that feature in DataStage. One option could be that A Sorter stage can be used and Key Change value could be obtaine...

if @INROWNUM<=RejectThreshold then @INROWNUM else RejectThreshold These two links are sent to the compare stage which also runs on a sequential mode. The compare stage has a property, Abort on Difference, which is set to True. Compare stage to a Peek Stage. Regards, The Bird. Hi, This is a good sug...

balki wrote:Hi,

I dont think that we can give wild cards in file pattern option. It can point to a file that contains a list of files which can be used as source provided all the files share the same metadata.

Balki

Sorry about this post. Yes wild cards can be used in the file pattern.

Hi,

I dont think that we can give wild cards in file pattern option. It can point to a file that contains a list of files which can be used as source provided all the files share the same metadata.

Balki