DSXchange

Hi I am having a staging table which is having amounts in it(different currency codes). i developed a job already as per my specs. But now we decided to convert all the amounts which are not in USD to USD. We build a lookup table which is having to_currency column and decided to do look up on two co...

Thx for the reply. So we need to give different ranges of satrt date and end date in each job sequence. I need to do partition first on year and then on period (1-12 for 12 months). My Where clause in main job is "WHERE tablLE_NAME.PERIOD_NAME = '#PERIOD#'. PERIOD_Name is a column in my source ...

I am thinking to create a job sequence by allowing multiple instances of the job. I decided to create 4 instances of the original job. I am thinking to partition the input data based on a period (as ia m loading only 2005 data). Periods are different. So this should be given as a parameter and in wh...

Hi I am getting around 40-50 million records from an oracle table. I need to do some join and simple transformations and load the data into another table. ODBC-->Transformer-->ODBC I went through the forum which discused the use of IPC, Multiple instances etc. I am thinking of creating multiple inst...

They DO match

Hi I am trying to do a simple lookup and it is not working. My jOb design is like this: ODBC1---->TX(llokup with another ODBC2)-->ODBC3 In ODBC1 , I am joining few tables. and based on the key columns obtained from it I am doing a lookup with the key columns present in ODBC2 to pull out one column. ...

So how can I call the function alone in an OCI stage.
Since this is a separate job, I am not understanding whether to do it in before or after or in normal user defined SQL.

And by the way I need to pass two table names as input arguments.

Yes. This is a function in oracle. We have a function code written
CREATE OR REPLACE FUNCTION Function_name
(table1 IN VARCHAR2,
table2 IN VARCHAR2
)
RETURN number AS

Hi I am having a function in Oracle with two input arguments. I need to call this function after the successful execution of my stored procedure. My typical job design is like this: I designed a job sequence. The first job activity is a normal job and second job activity is having a stored procedure...

There was an issue with missing columns. I used in the Incomplete column description "REPLACE". It worked fine

Hi Craig

I got it. I downloaded hex editor and found the delimiter. Thanks for your valuable suggestions.

I used &h20 for delimiter and quotes: "
It worked perfectly

Thanks once again

I tried to read with delimiter 009 and quote character ". The result was that entire input record moved into a single output column..

It also says invalid quotes.
Is this a problem with Metadata? or soemthing else.

I tried removing Quotes for the fields. I removed them. But when I am trying to read the file, the entire record is coming in the firsr field only. Now the i/p record is : asia 211 FY2001 890.00 987.0 78.90 Delimiter: 009 Quote: 000 In Output, the entire record is fitted into the first column only.

Yes Craig. It is compaining for each and every record. i deleted few records and tested it, but it was of no use :( . For the unequal number of columns, I am handling it by using "REPLACE" option in Incomplete Column field. Only few fields in each record has quote character. The amount fie...

I went through the entire file.
The problem is not because of unbalanced quotes. Every record is of the same type.

"asia" "211" "FY2001" 890.00 987.0 78.90
"UK" "432" "FY2003" #SI 89.00 87.00 12.00