DSXchange

column definition from oracle is number and metadata defined in datastage job is double with 15 length. Its working fine in 7.5.1a and it throwing error only when we run the same job in 7.5.3. I tried re-importing as well and no success, it showing same error. Error: DSD.BCiOpenR results of SQLCOLat...

We have upgraded datastage server 7.5.1a to 7.5.3. while running job which extracts data from oracle with columns defined as double, we were facing the metadata mismatch issue. Its happening for all the jobs which extracts the double datatype columns. Can anybody help in resolving this. Do we need t...

I have a CSV file as source and loading into Teradata empty table. Its direct loading. I have used TPUMP option in Mload stage. When I ran the job, its aborted stating "unable to start TPUMP process, errorno:2 system cannot find the file specified". But when we try to view the source file ...

Actually i have got the data like this as mentioned below in the input file and i need to separate them into rows considering ; as delimiter. Can you please assist me in this asap. I/P "AGAR";"AILR";"ASIR";"BIRD STRIKE";"CCAR";"CROSS";"...

ArndW wrote:Stage variables will work but you would also need to sort the data. ...

can you please tell what is the approach in transformer using stage variable after data being sorted.

duplicates by specific columns ?

Can anyone assist me in capturing all the duplicate records coming from csv file into a separate file without using aggregator.

Hi,

I would like to know how many sessions are logged in by a particular user thru the job and i need to send automatic alerts if more than 1 session is logged-in by a particular user. Can anyone help me on this. how can we know sessions related information in the designer.

What 'output'? Where are you writing this, to a sequential file? I'm wondering if a) they are even really there and b) if something you are doing simply puts them back in the output, hence the question about your actual target. Or is that (a target sequential file) where you are using 000 for the q...

trim(col1,' " ',"A") is not working.....can anyone give me the correct syntax . I have to remove the double quotes in the col1 where col1 is "Good Morning". If i use the above trim function, i have to get Good Morning with out quotes. Even i used 000 in quote character to s...

trim(col1,' " ',"A") is not working.....can anyone give me the correct syntax

I want to remove the quotes in a string using trim function, so can anyone suggest me what is the escape sequence in the 7.5.1 version.

Actually we have 7.x server edition, we are planning to migrate to 8.x(server or parallel). If we migrate from 7.x server to 8.x server, will there be any risks invloved and what abt the performance?. secondly if we migrate to 7.x server to 8.x parallel, will there be any risks invloved. Is there a...

How many versions are there in Datastage 8? what are the differences between the versions? Will all versions of 8.0 supports server jobs?if supports, will there be any performance improvements when compared to 7.x. Can any one pls provide me this information.

Is there any utility in datastage which automatically converts Oracle 8 stage to Oracle OCI stage, since we are upgrading the oracle from 8i to 10g. Need assistance on this? If so, how we can use that utility in datastage with example.