DSXchange

Hi,

I am using Datasets for lookup purposes in jobs Instead of Lookup file set .

Is there any con's(disadvantages) if i use dataset as lookup?

with regards,
mch

thanks for your answers...

Problem soved.

Basically in the transformed removed the addr_key column.

so i am having 22 columns in the target column definition.
now addr_sequence.next value and :1 -> :22

Its working fine now...

Hi all, Job: seq -> transformer -> oracle oci stage In user-defined query section in OCI stage, INSERT INTO table1 (ADDR_KEY,MODULE,KEY_VALUE_1,KEY_VALUE_2,SEQ_NO,ADDR_TYPE,PRIMARY_ADDR_IND,ADD_1,ADD_2,ADD_3,CITY,STATE,COUNTRY_ID,POST,CONTACT_NAME,CONTACT_PHONE,CONTACT_TELEX,CONTACT_FAX,CONTACT_EMAI...

thanks ...

But the solution you gave is temporary solution.

How to i automate it?

It would be great if you have answers for the others also.

regards,
Harsha

Hi, We are using oracle Enterprise Stage /Load method. Having 60 million records, we have to load these records from data set to Oracle stage. After loading 30 million records, the job aborted. I want to start the loading these records from 30 million +1 st record. a) Can you please explain how we c...

Hey,

Is it working using dataset as a look up?

If yes, please let us know.

Regards,
Harsha

All, We have around 50 jobs, where we are using one generic parameter file. Generic parameter file contains values for the 50 variables. We need to use these values in column derivation of our jobs. Not all of the job will use all of the variables. So, My question is Best method to use the generic p...

Yup........

Can you explain more what you will do in Filter/transformer?


Thanks,
Harsha

All, Input: Table A - Primary link A.key1 Table B - Reference link B.key1 Output: 3 Output Files - Get all the records which are in both the tables(A.key1=B.key1) - Records which are there only in table A - Records which are there only in table B Is the above output possiable using single look up st...

All, Input: Table A - Primary link A.key1 Table B - Reference link B.key1 Output: 3 Output Files - Get all the records which are in both the tables(A.key1=B.key1) - Records which are there only in table A - Records which are there only in table B Is the above output possiable using single look up st...

thanks buddy....

Got you....working fine :D

Thanks for you response. What i did: From Oracle Table Imported into Excel using sql developer, then converted into CSV file.(Windows operating system) Now here using as source file. Using Record delimiter string=Dos format, getting the following warning S1A2_ITEM_LOC_DC_NONWK1,0: Input buffer overr...

You are right..... Windows Seq file...

File End Delimiter : None

Hi,

Error Message:
S1A3_ITEM_LOC_WK,0: Import consumed only 24bytes of the record's 25 bytes (no further warnings will be generated from this partition)

Any info why we will get above type of error?

with regards,
harsha

Hi,

Can you please provide me info how to implement OR condition in lookups.

Ex:

Select * from table1
where table1.col1 in (select col1 from table2) or
table1.col1 in (select col1 from table3);

Regards,
harsha