DSXchange

Hi All, Will the lookup will work if the one of the datatype in Char and it is unicode. suppose my primary source having one column P1 of datatye varchar 25 (not unicode) and reference having one coulmn R1 of datatype Char 25(unicode), if i am going to lookup these P1 and R1 , will Lookup work in Da...

Arun,

you can go for Key based partition like HASH, and specify the Key and also you can use sort stage before Aggregation stage.

Hi,
can any one tell answers for these questions - Datastage:
1)how to check the processors which are used in datastage projects?
2)What are the major differences in architecture of datastage7.5 and 8.1?

Hi,

you can have a reject link in the target ,
so that if records are not in DD-MM-YYYY format the records go to reject file.

Hi All, I am getting data in CSV File and the date format is mm/dd/yyyy, in Sequential file i can't view the data so i made the datatype as Varchar and now i can view the data ,and my output format must be like this YYYY-MM-DD but when i run the job the job is getting Aborted. The error message is D...

Hi, I am using sequential file as target and i am getting the error in runtime. Error: Sequential_File_52: When checking operator: When validating export schema: At field "PRODUCT_E_DESC": Exporting nullable field without null handling properties. While i am loading into to file, i am gett...

HI,

Can a written stored procedure script in Teradata Multiload stage(it is target), will this work?

File-->TNSF stage--->Teradata DB(target)

Help me how to call stored procdure in datastage job(irrespective of any stages we use).

Criag, thanks for helping me about your valuble inputs. A procedure is a specified series of actions or operations which have to be executed in the same manner in order to always obtain the same result under the same circumstances. Let me know if i am wrong. I have a requirement like i need to call ...

Hi

In ODBC stage we can select the table or we can write user-defined SQL,
my requirement is to run a teradata SP from datastage.can you explain briefly how to do so?

Craig,

In Datastage7.5.3 the stored procedure stage will not support the Teradata database.

Hi, I am using Datastage7.5.3. How to call stored procedure in Transformer stage, is there any logic or alternative methods for this. I need to call the stored procedure in my requirements. Source(File) -->Transformer(STP called) -->Target(Teradata) - Will this work? (And) How to check the stored pr...

Hi All, i am getting the fatal error like [IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Warning: Fatal error 625 occurred at Jan 6 2011 7:00AM [/b] my job is running on 2-node and source & target is SQl-Server-2000 and i searched in the forum also i had not got enough information abou...

HI

what kind of key based partitioning method we should use,
i tried with Entire Partitioning,but the records are doubled,and also i suspect we cannot use round-robin,because some records will go into 1st node and some will go into 2nd node,
can anyone explain on this ?

Hi All, my requirement is ,i am using join stage and also look-up stage s in my jobs,what is the best partitioning method for Look-up stage as well as Join stage . i am running on 2-node config file. by default i am using auto-partition though we give this as Auto -partitioning,what type of partitio...

Hi,

convert the integer into varchar and then concat it.