Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums    Search    Search Results
Page 1 ... 7 8 9 10 11 12 13 ... 20
Go
New
Search
Tools
Search Results: (384 matches) New Search Login/Join 

Discussion Topic  RE: Using statistical variables in the Data flow to load a log table (in iWay Software Product Forum on Focal Point) by Clif
When you Submit or Schedule a DataMigrator flow the statistical variables are written to DataMigrato......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: (SOLVED) Unable to Pass Parameters in CMASAP (in iWay Software Product Forum on Focal Point) by Clif
Please see my answer posted May 07, 2009 11:38 AM. I believe it applies to your situation....
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Data Migrator 7.7.03 slows d-o-o-o-o-w-w-w-w-n-n-n-n (in iWay Software Product Forum on Focal Point) by Clif
I just want to let you know that our developers have rewritten the XML output routines for 7.7.06 to......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [CLOSED] Using common table expressions (CTEs) in DBMS SQL Flow (in iWay Software Product Forum on Focal Point) by Clif
Because the MS SQL Server error message complains of a missing semicolon I have suspicion that the i......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: laod is taking more than 17 hours (in iWay Software Product Forum on Focal Point) by Clif
You say you are loading a 4 million row fact table. But it looks like you are using a load type of ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Function: Lookup_MFD (in iWay Software Product Forum on Focal Point) by Clif
I couldn't figure out a way to use LAST to solve the problem as you've described it. Perhaps someone......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Function: Lookup_MFD (in iWay Software Product Forum on Focal Point) by Clif
The select is passed through to the underlying relational database which optimizes the sub-select. ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: (Foc14006) SQL Translator Error Null join to table holdtable() (in iWay Software Product Forum on Focal Point) by Clif
Your signature says WebFOCUS 7.6 but since support for sub queries was added in DataMigrator Release......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: SQL Join and NULL Values (in iWay Software Product Forum on Focal Point) by Clif
While I think the term "best practice" is overused because "best" is subjective but for loading dime......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: DataMigrator cmrun 64-bit (in iWay Software Product Forum on Focal Point) by Clif
It's not quite clear what you are trying to do. You can install and run CMRUN on any platform. It'......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: create table for sql server in data migrator using stored proc (in iWay Software Product Forum on Focal Point) by Clif
Assuming you want to use your first connection and Test_SP is a valid database name, all you need to......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [SOLVED] DMC Variables - Job ID (in iWay Software Product Forum on Focal Point) by Clif
Do you just want the name of your flow? That's just &&CM__REQUEST. Or do you want the system gener......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: To Migrate Oracle Database in Sql server (in WebFOCUS/FOCUS Forum on Focal Point ) by Clif
If you want to copy entire tables (all rows and all columns) you can use the so-called "Quick ETL Co......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [Solved] Building SCD Type 2 Using Histroic Data (in iWay Software Product Forum on Focal Point) by Clif
Yes, although not every day for the past five years, just those on which there were changes. So ru......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [Solved] Building SCD Type 2 Using Histroic Data (in iWay Software Product Forum on Focal Point) by Clif
Answering your questions in reverse order. Actually you can select BOTH activation flag and begin/e......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [CASE-OPENED] DB2 bulkload truncates char fields with double quotes (in iWay Software Product Forum on Focal Point) by Clif
In researching your hottrack case we determined that the DB2 bulk load program defaults to treating ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Best way to ignore a surrogate key when loading a table through a flow (in iWay Software Product Forum on Focal Point) by Clif
For columns that you never want to update you can identify them a "Permanent" by leaving the SCD typ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Best way to ignore a surrogate key when loading a table through a flow (in iWay Software Product Forum on Focal Point) by Clif
The ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [CASE-OPENED] Pivot a source with unknown upper limit number of records (in iWay Software Product Forum on Focal Point) by Clif
Indeed LISTAGG is in DB2 9.7. Also ORACLE 11g Release 2. I'm glad that will work for you. MySQL ha......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [CASE-OPENED] Pivot a source with unknown upper limit number of records (in iWay Software Product Forum on Focal Point) by Clif
I see from the hottrack case that the source is a DB2 table so you can take advantage of the DB2 fun......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 ... 7 8 9 10 11 12 13 ... 20 

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.