DSXchange

Thanks for your response,

Can you just explain more briefly about this (or) is there any documentation for this, because i am facing a lot of problems in installing sap packs. now we are moved to 5.2.1

it is giving an error message:- Installation failed.

Thanks in advance

I am trying to install sap packs to the datastage parallel edition,

do i need add any .dll files to this,

Can any one giv me an idea and procedure need to be followed.

thanks in advance.

Can any help in this issue.

Hi ,

From which version onwards Datastage provided SAP PACKS (PLUGINS),

Can any one give me an idea,

regarding ''BAPI'' PLUGINS in datastage.

Thanks.

yes Ray, it is Environment Variables.

How to pass the environment variables from unix, when the jobs are migrated from dev-test-prod.

Please give your valuble suggestions.

Thanks

Hi,

How to pass the job parameters in datastage jobs for different environments using profiles(unix).

please help me about process,Any documentation regarding this is helpful.

Thanks for your help.

Folks, I have two tables A and B. These two tables are created in such a way that Table A has a parent key relationship on few attributes in Table B and Table B has a Parent Key relationship on few attributes in Table A. I need to do destructive loading on these two tables every night.I now I can dr...

I am using the reject link,

but i am getting the rejected rows, beside the rejected rows i am getting the warnings with row information, warning of integrity constraint.

Hi DSGURU,

please explain clearly how to check the codevalue and what is the code value.

Thanks

I mean supose there are two tables. table A, table B table A --- parent table i already loaded the data into tableA. now when i am trying to load the data into tableB, it is giving integrity constraint error. My opinion if lookup with parent table (table A) and table B on column which we are getting...

i loaded the parent job first, Again i am getting the same error,
can i use lookup with that table with this job and load the data,

which option is better:-

drop the constraint (or) using lookup with the table.

on the same column.

Please help me.

Thanks,

Hi,

i am getting the following error, the records are not loaded into the target, and giving warning messages.

ORA-02291: integrity constraint (schema name.CONTACT_PERS_FK) violated - parent key not found
DBMS.CODE=ORA-02291

Please help me.

Thanks in advance.

The target (oracledatabase) "DATE"

Thanks for the response.

Hi deepak/Thumsup9,

please suggest me which is the exact format

D-DMY or D-MDY

and i also checked there are no spaces in the function.

i tried for both,but it is not loading any data.

please help me .

Thanks in advance

Hi, first scenario:- source database:- oracle date(column name) --- varchar target database:- flatfile date(column name) ---- varchar can i use any function for this. Second:- source flatfile:- date (column name):- varchar Target database:- oracle date(column name):- Time stamp. i am using this func...