DSXchange

Hi Munish, Rather than finding a way to insert duplicate rows in table, find the reason why you getting duplicates to the table. And work at the root cause. If its the table that ought to have constraints, the Extract and transformation should be made in such a way that it suites the target. Considi...

And while creating a post, give a meaningful title to the post, so that it will help those who try to help you as well as for those who make a search in future.

If you do a search for each error message, you will ultimately end up in understanding that you are running short of resource.

Hi Sudeep,

If you check the previous post, you can find that the Lookup does both inner and outer join by it self.

Try changing array size and transcation size to 1. So that you can force record to flow one after other, rather that caching it up.

Are you checking the log for the Sequence or for the Job2? Is the log for the Job2 shows its running?

Constraints are ok. But you may need to check the actual value after getting converted into internal format. For testing purpose, add three more column and pass on the derivation as Iconv(DSLink1.TERMINATION_DATE,"D/MDY(2,2,4)"), Iconv(DSLink2.ACTUAL_OPEN_DATE,"D/MDY(2,2,4)") and Iconv(DSLink2.ACTUA...

You can use Nested contition Activity next to User Variable Activity and branch both the Job Activity stage based on different condition.

Were you able to send the mail to your local network mail group?
You may need to set up each smtp for each mail group. eg: smtp.google.com,smtp.mail.yahoo.com

So is it you got the solution or expecting something else. If yes, you can close the post.

Yeah, possibly a '/' next to '/apps/source/ds' your path might be missing. You can mark the status of the topic.

Lookup does the outer join based on your input stream. The other conditions are to state how to the lookup stage can react with the records when it doesn't find a match in the lookup stream.
Do a search, you will find some related post..

If I understand properly, the joiner table will have the set of keys the links both dimension table. But let me know, why do you want to do this, if you can join the dimension tables directly using Fact tables. After all the dimensions can be purposefully used only after joining with fact table.

I was able to see another very relevent link in google but that was in Ask Tom premium members.
But its good that we have another Tom (DSguru2B).

Awesome!!