DSXchange

Sure buddy, Check this out from the technical documentation: "a Lookup stage might thrash because the reference data sets might not fit in RAM along with everything else that has to be in RAM. This results in very slow performance since each lookup operation can, and typically does, cause a pag...

I'd suggest using Join stage. Look up stage with so much data can lead to memory leaks/corrupted data. Also, is the data coming from the reference link is bigger than the main stream? If yes, then this is an additional reason to use the Join stage. Overall experience, with big data cases like this o...

You gotta use Transformer. For that column use Convert to date, and between the ( .. ) concatenate ( '01/':LinkX.YourDateColumn )

Happy DataStaging

Of course you'd have it look like that! Here's what to do: in the stage before that stage which got the varchar type, it's either numeric or decimal, correct? Now, in that stage, clear the precision or limit it. If the stage before it also have the type of varchar, keep tracking back the stages till...

Or yet better, use join stage. It's much faster and efficient. Trust me, lookup might put in situations where you'll say "Huh?"

Just a thought, and a little bit of experience

Transformer, Stage Variables and Partitioning with sorting are your best friend in this case. Put some logic, you can treat the whole as a single column or segment them to different columns (but that's dependent on the type of separator you have ,for instance it could be space). In the transformer u...

Well, I guess thanks for trying to help. None of those worked out.

Maybe just CDC is the best replication tool and does not meet our full requirements, and made for smaller businesses.

Technically I'm frustrated with it. If anyone can share his/her experience with it, please do here.

Cheers.

Hi again, None of the tables is compressed, IOT or clustered. For the second though, I believe CDC is looking in the correct directory. But how can this be configured through dmconfigurets? I thought CDC looks for oracle configuration file to get those destinations.. Any comment on this one? Another...

Hi, Thanks for your reply and excuse my delay in response due to 90345 jobs I have at the moment :) Well, for case 1 the version is 6.3 with the latest 25 something patch. There is only one subscription which is dependent the source agent. Target is being used as target (obviously) as well as source...

Hello guys, I desperately need your HELP! Case 1 It's about CDC. A quick overview: Source: Installed on Solaris (latest patches applied as recommended by IBM) Target: Installed on hp-ux (latest patches applied) TS: Installed on Red Hat Server (also latest patches applied TS Client: On Windows XP wit...

What you did is correct, obviously. Had the same problem and I knew about this hosts file before and an entry should be added, and I did add one, but still faced the same problem. Thing is the IS is installed on RH server, and the hostname was redhat_ds. localdomain I only added redhat_ds and it gav...

Hi, It's me again (to those who came across on my other post), with another question :) Is it possible to process a BLOB column in DS? What stages can work with and stages can not ? (most used) Importing Orchestrate is already not working when importing a table that has a BLOB. Any suggestions? I re...

Hey guys..

Thanks for your replies, you guys definitely gave me a better perspective.

I must say that ankesh solution worked like a charm, thanks buddy!! Simple and straightforward

And thanks again everybody.

Cheers (:

Hi, This is my first post here, been reading a lot of posts on this website, pretty interesting. Anyway, I am facing this issue: I have the following data <pre> DM_OPERATION ID REASON_CODE ---------------------- ------------------- 4 158 4 156 4 865 4 901 4 483 </pre> I need to output them as <pre> ...