DSXchange

Thank u.Now after giving it as Stringtodate(input_col,"%yyyy-%mm-%dd") the job is running fine.It is converting it in the format yyyy-mm-dd.
But i want to convert it into mm/dd/yy.How can i do this please suggest.

In source there is a char field with this format yyyy-mm-dd.I need to convert this into date with this "mm/dd/yy" format. I am using the function Stringtodate(input_col,"%mm/%dd/%yy"). The job is getting aborted with the error "Data string '1972-09-' does not match format '%...

ProfileStage DataBase (PSDB) Repository is in Oracle. To connect this repository from analysis server we have created a DSN through Oracle IBM wire protocol.We also have one DSN to connect to source database(File database present in Unix server) from analysis server. But we don't have any DSN to con...

Hi,

I am very new to profile stage.While running report in profile stage after running job for column analysys I am getting the following error "Error Printing report 20599-Can't open SQL server".

Please help.

Thanks
Shaonli

Hi, I am very new to profile stage.I want to make connection between the analysis server and the source database of profile stage.In my case some flat files have been put in the server path.I am not able to make connection to that source or import metadata. I have only established connection between...

I looked into the MultiLoad report.There I found this statement ========================= 0003 drop table ABC.ET_ABC; **** 23:13:58 UTY1008 RDBMS failure: 3807, Object ABC.ET_ABCdoes not exist. 0004 drop table ABC.UV_ABC **** 23:13:58 UTY1008 RDBMS failure: 3807, Object ABC.UV_ABC' does not ========...

Hi, In my job data is getting loaded from dataset to teradata table with load utility Multiload. The job is getting aborted due to this error "Fatal Error: Fatal: Unable to start MultiLoad process : MultiLoad failed:" I am not able to get anything from this message. If anyone from you have...

Thanks for the inputs.
I don't have access to change the jobs.So there is no option other than supressing the warnings in the log.

Thanks
Shaonli

In my job there is change capture stage.The i/p is two source file.Now the there are 2 targets. One target captures the new records and the other one captures the same records. Now in the change capture stage the option Change Mode="Explicit Keys & Values" has been set and the change c...

Thanks Abu.I am able to do it following your steps.

Hi Abu, Thanks for yr suggestion. But with this option I am not able to track the first record of the duplicate groups. If I go with your option then DUPLICATE TABLE WILL HAVE 1 A 20 2 B 30 2 B 10 NON DUPLICATE TABLE WILL HAVE 1 A 10 ------------------It should not be populated in this table. 2 B 10...

There is two different flow in a single job.
One flow is populating to the parent table.
Second flow is populating to the child table.

I want to execute the parent flow first and then the child flow.

src->tfm->parent table
scr->tfm->child table

Please suggest.

I have a flat file which contains duplicate and non duplicate records. Want to route the all duplicate records in one table and all non duplicate records in another table in a single job. Eg: SOURCE FILE: ID Name Marks 1 A 10 1 A 20 2 B 10 2 B 30 2 B 10 3 C 10 4 D 10 NON-DUPLICATE TABLE: ID Name Mar...

I am not able to login in UNIX box with userid xxx where datastage server is installed.Cron is used as scheduler.
Job was scheduled with the userid xxx..Cron is not able to call the job.
But I am able to login in Datastage director,designer with that userid.

Please suggest.

Hi, I need to design a job which will import all XML files in a directory of a remote server and put it into a specific path of a DS server. Then a job will run which will process all the xml files. How to import all the XML files(names are different) to DS server. I looked into ftp stage.But I have...