DSXchange

Hi All, I have earlier worked on Datastage 7.5 and my new client is installing 8.0. I came to know that it uses a database like DB2,Oracle and SQL server to store its metadata unlike 7.5 where it uses Universe. What are the other differences. I dont want to get lots of surprise. Is the quality stage...

Yes I can browse and select the pah name but that too didnt work. Suppose the path is c:\folder\filename.ds then it would work if I put c:\\folder\\filename.ds in the path or can pass the earlier path through parameter. What about the check button in the manager configuration window why is that disa...

yes I can browse .

1.There is a problem when I directly type the file path for the Dataset in windows environment. But the Dataset is created when I pass it through the Parameter. Again I found that I have to add a extra '\' before every '\' we encounter in the path. Is there any constraint ? This thnig only happens f...

In a transformer a record can be dropped based on condition but not a whole column.It doesnt sound logical can you explain it more briefly.

In CDC Stage you will get the updated, copy, insert and deleted records based on the logical keys you have defined.

We have direct one-to-one mapping date mapped to date field and Timestamp mapped to timestamp.
The timestamp in the target is fine but the date is reduced by one day.

I tried searching the forum but couldnt find a similar post.
if you could please guide to the right link.

Yes

What does the message file says?

Its date on both side.

My source-target date field mapping is one-to-one.

Suppose my source date is 2006-07-28 but i find the same date has been converted to 2006-07-27 in target

Hi,
I'm facing this very strange Date problem where I'm mapping a Date field of DB2 API(Source) to another DB2 API(Target) with a transformer in between at the target the date becomes:

Target Date= Source Date - 1 Day

where as Timestamp mapping is working fine.

Any clues ?

Hi,
You can try this.
1.Filter the input set into 3 datasets based on the second column value.
2.Merge the 3 datasets based on key column

Let us know if it works.

Hi,
Do we always have to key partition data before a lookup/join as Ray suggested or there any special case when we do this as my join/look up working fine without this, or i'm missing something ?