DSXchange

Raju, After more research, I found that I used this key function as a variable. And I should not do this for the second job to insert into existing table. I changed the logic and put it as derivation for primary key and this function does the job (continue incrementing sequence when it was left from...

Unfortunetely,
my sequence increments each time differently. It is not right sequence and I can not find a pattern. I mean, it is not incremented by same number.

Hi, All! I loaded information into the table(created rows). For unique sequence I used KeyMgtGetNextVal function. In a future, I would have to add some new rows from different file(output) as an input to the table. In this case, how would I use KeyMgtGetNextVal to continue sequence number where it w...

Sorry Ray,
I used Trim function which limit the number of characters that could be output.

Trim(Field(From.CM_CLT_CITY_ST, "," , 2))

Thanks

Thanks John,

It is working now.
I appreciate your help.

Thanks,

It almost helped
First for 'CITY' is excellent, while for 'ST' data is truncated and message
appears as "Inserted value too large for column, row rejected".
Would Trim function will help?

Hi, Everybody! My queston could be a simple for somebody. I have a field where 'CITY' and 'STATE' info stored separated by a coma. I have to parse 'CITY' info by a coma and 'ST' info after a coma, coma is not included in any target fields, into two different target fields. Below is a derivation that...

THANK YOU ALL.

Ray, So, if I do this task in separate jobs how would I assign the ID from master table to foreign key of Detail table if I can't see the ID from Master table in the second job? I can not load a detail table without information for foreign key (derivation). Also, can you explain changing demantions ...

Roy, The data that suppose to go to different tables is on the same row, but some info should go to Client table while another to Addr table and I do not see that. Also, I will check constraint on second table. Let see. As I understood, I would be able in the same job write to multiple tables for sa...

I am still confused. I have one out file (CFF stage) wich link to the transformer. From the transformer two references links to Oracle stages( For ex: one to Client table other two client_addr). In my situation after job finished, event detail specifies ClientMastJob..HoldCltMast: DSD.StageRun Activ...

Hi All, As we know, the Oracle stage (ORA 9i) can have a single input link and a single reject link, or a single output link or output reference link. [b]The Oracle stage can have only one input link writing to one table.[/b] My question is how we would relate data between Oracle tables, otherwords ...