DSXchange

Hi With the help of mike's post i an finally able to complile the routine,but its not working properly in transformer. my code is :- #include<conio.h> #include<stdlib.h> int sum(int a,int b) { int c; c=a+b; return c; } When i am compiling its giving following warning :- c:\Program Files\Microsoft Vi...

Hi,

Can anyone help me in this topic..??

Hi All,

I have installed datastage 7.5 in my laptop and also installed .net 2003.Here i have created c++ routines and i want to call it in transformer.For that i need to generate object file.But i dont know how to create that object file in windows.

Can anyone help me.


Thanks

ray.wurlod wrote:The next version will have server-side export and import. ...

Is istool available in 8.0 window version of datastage..or we need to install some patch for that..??

DataStage will detect that difference and resort implicitly (turn on APT_DUMP_SCORE to check). If you disable this functionality, i.e. through APT_DISABLE_SORT_INSERTION and sort your two links differ ... So in case of join,merge always we need to do hash partiotions and explicitly sort(if not inte...

chulett wrote:"but if sorting condition will not be same"? Sorry, what?

Well i mean to say if in left input link i explicitly made it decreasing on the sorted key col. and in the other link i changed to increasing,so in that condition output will be correct..??

The join stage will first sort the input streams according to your join key(s), unless that has been already done or explicitly turned off. That way the join mechanism can process the data without hav ... ok that means it sorts the data on the input links and performs join on the sorted data......b...

This is interview question

Hi all, Can anyone tell me how join stage really works? Well suppose i have two i/p datasets & partitioned on four nodes and i m performing join on one key column. 1) will join stage first performs join on both i/p datasets on first node then second and so on.....and fetches the records to downs...

Hi all, I have two date columns in source file in timestamp format CALL_START_TIME and CALL_END_TIME . Here i need to pick only a record that has maximum call duration i.e. difference between Call_END_TIME(HH:MM:SS) and CALL_START_TIME(HH:MM:SS).So here i can skip date part,but is there any function...

Hi, i have a job in which i m using join stage,and source of the join stages are one dataset and one db2 api.Here i m performing inner join basced on key column. On the dataset link i have used same partitioning and on db2 link i have used hash.Job is running fine,but i m getting worning in log abou...

ddevdutt wrote:Using Change capture you can achieve splitting your data into inserts, updates(edit), deletes and copy.

Once you have your different sets of data you can process them accordingly.

what will be change mode in my case..???

In other words what i want to do is:- 1. i want to perform a join on natural key column(PARTY_ID) and saperate the new records from old records. 2.assign the key for new records 3.update the old record with END_DATE of new records START_DATE. How can this be captured using Change capture stage..?? .

Hi, There is very srtange problem coming with datastage server restart.Well someone has stopped our datastage server but few processes was still running ,then datastage server was stopped.then it was started. Now we are able to login to designer client successfully,but when we check on server with t...

Depends on the version I think. If you use 7x, yeah, Change Capture should be the correct one as it allows you to compare new data with the old one. Otherwise, if you're using the 8x version, you might think of using the SCD stage but only if you use surrogate keys. Yes my datastage version is 7x.I...