DSXchange

Found it in the orscht folder

I have the "material_code" column in the the input oracle stage and I have the "material_code" column coming from the lookup sequential file stage. Now you want me to write a condition in the constraint of the lookup stage saying => lookup_input_Link.Material_code <> '' . Is that...

Here is my problem. I have an input source from an oracle database. It has some "X" number of columns and key column is the "MAT_CODE". Then there is an excel sheet with only "MAT_CODE"(Key column) which is suppose to act as a lookup on this source oracle and the only t...

Hi all I am not able to compile a job. The reason for it not getting compiled is since I have one of my column value coming from the "Job Parameter" and that job parameter is defined at project level. If the value is defined as Job level parameter then I am able to run the job successfully...

I am trying to load to the SAP BW from a sequential file stage. I am facing a time out error. Althought the job shows all green. It does not gets in BW and job gets aborted. Following is the error: ZACTIONCD_ATTR_Ldr,0: Failure during execution of operator logic. ZACTIONCD_ATTR_Ldr,0: Fatal Error: F...

I get the following error HRY065_TRANSLATE_TBL_LGCY_Ldr,4: The system(sqlldr DEVL1_DB04FDWP/edison1358@ORAP062 CONTROL=ora.1577054.869903.4.ctl LOG=ora.1577054.869903.4.log BAD=ora.1577054.869903.4.log.bad SILENT=header PARFILE=ora.1577054.869903.4.par) failed; see the log file for the Oracle specif...

Table 1 has 1000 records and 4 columns, table 2 have 1000 records and 3 columns. One column is common between both the tables. I am doing an inner join on that one column. But the output I get is 10,000 records. Its sort of multilying the data and producing the output. Following is the scenario: Tab...

I have joined two tables with an inner join. Table 1 has 5000 records and table 2 has 5000 records. The expected output cannot be more than 5000 records in this case. But I get way beyond 5000 records. It seems to me that the join is doing a cartesian product of both the tables. Can any one suggest ...

Is there a way if we can produce a file for each record that is present in a table using Ascential. For example if I have 10000 unique records in a table can I have each unique record in a different .txt file as output. Please tell me if it can be done in Ascential. I need to convert a table which h...

Hi All I am doing a job to load into SAP system using an IDOC. The logic is very complex. I am sending the data one to one into all the SAP IDOC's, I do not have any kind of error while loading also. But there is one SAP IDOC Segment which is suppose to store 4/5 values for each primary key column. ...

I am trying to do the following logic. Two tables TABLE1 and TABLE2 are to be joined depending on the EMPLID and EFFDT. Where ever there is a match the TARGET TABLE will have the EMPLID, EFFDT, HIR and the PAYROLL_NBR respectively. Whenever the EMPLID and EFFDT don't match the EMPLID, EFFDT and HIR ...

Thanks DSGURU let me work on it as you said and if I have any problem I will open this question again. Thanks for your help again.

Thanks DSGURU let me work on it as you said and if I have any problem I will open this question again. Thanks for your again.

I did not demand any quick responce. Just curious at work. I thought some one might give a good answer to me. Anyways thanks and if i have more questions i will keep it posted.

I did not get any reply for my question. Which stage should I use to load to an SAP BI Info Object. Is it SAP BW Load stage????