DSXchange

Hi,

I am running the sql query using "read select statement from file" in Oracle connector stage and I need to pass job's parameter value to this query at run time like extract date.
Can you suggest how we can pass the Parameter to sql query at run time.
I am using DS 8.5 version.

You can use column generator to generate the additional column for all the records and define the fixed value for that column

You can use convert function in transformer to convert the values like 12,000 to 12000 and then use StringToDecimal to convert into decimal.

It can be implement in different ways based on requirment. You can use 3 lookup stage. In first lookup,lookup on first file and reject the unmatched record. In second stage, lookup only for rejected record and reject the unmatched record. in third stage, lookup the rejected records from second looku...

Use the transformer stage and Date function to substract 2 dates..

Partition the Data in Transformer stage and use unique record option. You can remove duplicate record.

Below mentioned is the example how Pivot stage works... The input link Columns page contains three input columns with sales data: JAN_Sales, FEB_Sales, and MARCH_Sales. The columns are as follows: The data for the source rows for the input columns looks like this: Input Source Rows CUSTID LNAME JAN_...

SeqFileStg1----->Funnel-------->Aggregate Stage(Aggregate on File Name)
SeqFileStg2
SeqFileStg3

You can use filter stage after reading the data from multiple files to drop the rows which is the header of the file.

Hi,

You can use Schema file and provides the csv file name and schema file name at runtime. Also enable the RCP while using Schema files.

To count the number of records in each file, you can use File Name Column property of sequential stage and then using aggegate by grouping on file name, you can count the records in each file.

Thanks all of you for sharing your thoughts. It helped me a lot to understand the load process .

I think this parameter is used $APT_RDBMS_COMMIT_ROWS DB2 database. Still it is not considering this parameter values for commit.

Hi,

Is there any way to increase the commit frequency when loading the data into oracle table using Load and Appened method. Right now Commit points occurs at 64 rows by default .Also, If i used OPTION(DIRECT=FALSE,PARRELEL=TRUE,ROWS=1000), then commit point occurs at 587.

Just check the datatype of END_EFFCTV_DT whether it is date or Timestamp. If it is Timestamp then assign the value like '2099-12-12 00:00:00' . I am using in this way and it is working fine.