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 ... 19
Go
New
Search
Tools
Search Results: (380 matches) New Search Login/Join 

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

Discussion Topic  RE: features of Data migrator version 7702 and 7705 (in iWay Software Product Forum on Focal Point) by Clif
Each edition of the DataMigrator User's Guide contains a Summary of New Features in the Preface....
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Insert Record From Memory -- What Happens if Record Exists? (in iWay Software Product Forum on Focal Point) by Clif
Furthermore, Insert Records from Memory, as the name implies is an insert only operation. If you nee......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Data Migrator Table Unions (row limit?) (in iWay Software Product Forum on Focal Point) by Clif
There is a DataMigrator UNION object but DM generates SQL SELECT statements and if possible passes ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [CLOSED] Data Management - Target question (in iWay Software Product Forum on Focal Point) by Clif
......
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 ... 19 

Focal Point    Focal Point Forums    Search    Search Results

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