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.
Search found 56 matches
- Fri Mar 20, 2015 2:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing Job Parameter value in Oracle Connector Stage query
- Replies: 2
- Views: 3593
- Wed Sep 03, 2014 11:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup without a key column
- Replies: 4
- Views: 3179
Re: Lookup without a key column
You can use column generator to generate the additional column for all the records and define the fixed value for that column
- Tue Jul 08, 2014 8:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Modify Stage decimal_from_string
- Replies: 7
- Views: 6435
Re: Modify Stage decimal_from_string
You can use convert function in transformer to convert the values like 12,000 to 12000 and then use StringToDecimal to convert into decimal.
- Tue Sep 14, 2010 8:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Implementing OR condition
- Replies: 8
- Views: 5173
Re: Implementing OR condition
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...
- Tue Jul 27, 2010 12:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How can I subtract two dates in a Parallel JOB?
- Replies: 5
- Views: 3831
Re: How can I subtract two dates in a Parallel JOB?
Use the transformer stage and Date function to substract 2 dates..
- Tue Jul 27, 2010 12:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to remove duplicates in transformer stage..?
- Replies: 6
- Views: 6093
Re: how ro remove duplicates in transformer stage..?
Partition the Data in Transformer stage and use unique record option. You can remove duplicate record.
- Thu Jul 09, 2009 12:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivoting scenario
- Replies: 5
- Views: 3195
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_...
- Wed Jul 01, 2009 12:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: create control jobs to get the record count in the target
- Replies: 7
- Views: 3172
- Wed Jul 01, 2009 12:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove Header
- Replies: 10
- Views: 3816
- Wed Jul 01, 2009 12:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: configuration set up
- Replies: 1
- Views: 1456
Re: configuration set up
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.
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.
- Tue Jun 30, 2009 11:54 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: create control jobs to get the record count in the target
- Replies: 7
- Views: 3172
- Sun May 31, 2009 1:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: commit frequency in Oracle Enterprise stage
- Replies: 10
- Views: 6719
- Wed May 27, 2009 2:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: commit frequency in Oracle Enterprise stage
- Replies: 10
- Views: 6719
- Tue May 26, 2009 11:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: commit frequency in Oracle Enterprise stage
- Replies: 10
- Views: 6719
commit frequency in Oracle Enterprise stage
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.
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.
- Tue May 19, 2009 11:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SCD stage END_Dt column derivation
- Replies: 3
- Views: 3582
Re: SCD stage END_Dt column derivation
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.