DSXchange

Thanks for the information

Hi All, I tried to search it but couldn't find it. It might be as easy as clicking mouse for a couple of times but need your help. I have one datawarehouse schema and we need to do some experiments with that. So we have provided space to copy the whole schema with all constraints at some other place...

Hi All,

can anyone suggest the easiest way to get distinct value in a column.

Thanks,
Sylvan

That was the only reason behind it. Thanks.

Now can you help me to figure out a way So I can upload a constant string type in date type OCI stage.

My misunderstanding. I had seen the name not the quote.

thanks a lot Jules.

Thanks for the reply. I have got two options. One is start date and other one is end date. Start date could be anything or null and end date is 12/31/2999. Both are constant. And I need to fill them in target. As I told you only the startdate is from input OCI8 which could be NULL. And Enddate is co...

It is Date type and I don't want to change it.

Thanks gateleys

Hi Jules, Thanks a lot for the reply. Well I am just trying to pass a string 12/31/2999 to date but as it is not valid So it is returning junk values. I also used the following function: Oconv(Iconv('12/31/2999', 'D/MDY[2,2,4]'), 'D/MDY[2,2,4]') but still it says input invalid. But if I use output t...

Thanks for the reply

My source is Oracle OCI8 and same is target.

Sylvan

Hi All, I got something interesting while creating a job. I had one constant input date which is 12/31/2999. When I connect to output link and run the job. I see 12/31/1967 instead of 12/31/2999. Also if the field is nullable then how can we just leave the space empty in the column. Any suggestion. ...

Thanks for your reply. Well...you were right as we were two people colliding there. Anyway we sort out the way. And now we have restored the RI.

I only needed to delete the links and connected them again. Redefined them and run. It worked.

Thanks,
Sylvan

Hi All, I was overwhelmed by yesterday's response. So I am here again with a very simple problem. I have two stages in ORACLE. Data is migrating from one to two with a bit of transformation. There is no relationship in stage one but it exists in stage two. So when I try to migrate the data I get the...

That was awesome. Thank all you people. I din know it is so good here.

Thanks again,
Sylvan

Thanks for your reply. You are very true. We have email address and we are generating equivalent ASCII value. Well your suggestion gives me value for first character. Is there anyway I can do it without using a loop.

Sylvan