DSXchange

Hi, In one of our requirement we need to migrate the Informatica 6.2 Repository into Ascential Datastage 7.5.1A, we came to know that MetaBroker supports importing & exporting Metadata within BI Tools like ERWIN, Informatica, BO. Would like to know how the datas are stored in the Datastage Repos...

Hi, Could u plz help me.I could not understand the following error. When i am executing the job it is getting aborted due to the this error. DataStage Job 69 Phantom 5812 Program "JOB.2071183520.DT.1389044232.TRANS1": Line 103, Unable to open the operating system file "RT_BP56.O/DSU.T...

Hi All, i have only one field in sequential stage component. let suppose edate which is having data 20051208 and datatype is varchar. And also i have only one field edate(datatype DATE)in xyz table in Oracle database. So, plz tell me which function i will use in Iconv() and Oconv to convert it into ...

Hi ,

How can i use the User Account Name in Hash file.




Cheers
prithivi

Use a UNIX level sort (or if you really want to, use a sort stage) to sort your input data - optionally the sort program can and will remove duplicate records for you. If your data is sorted, then you can use a stage variable in a transform stage to compare the current record with the previously re...

Hi, How can i remove the duplicate records by using a sequential stage componenet. my flow is like this... Sequential stage--->transformer--->sequential stage/Oracle OCI suppose i am using a flat file as a source and it has having some duplicate records.I need to remove those duplicate records in tr...

Hi, How can i convert a date value which is in dd/mm/yyyy format to yyyy/mm/dd format into oracle table i mean my source is a flat file which is containing a date value in dd/mm/yyyy format and target is a relational table(oracle) I have used the following conversion in tranfomer OConv(IConv(DSLink3...