Topic Topic Starter Replies Views Last Post [CASE-OPENED] Creating Log and statistical Tables - Data Migrator Balaji 1 6226 November 22, 2013 07:29 PM by <Kathryn Henning> Using statistical variables in the Data flow to load a log table Balaji 4 6178 November 22, 2013 10:31 AM by Clif [CASE-OPENED] Command Task in Iway Data Migrator Balaji 5 7263 November 22, 2013 10:28 AM by Clif November 14th Webinar: The Power of MDM in a Big Data World Kathleen Butler 0 4779 November 12, 2013 11:45 PM (SOLVED) Unable to Pass Parameters in CMASAP Shruthi Joshi 8 12684 November 11, 2013 11:09 AM by Clif DATEADD but in Focus Variable? cs_source 5 9406 October 30, 2013 12:25 PM by cs_source Data Migrator 7.7.03 slows d-o-o-o-o-w-w-w-w-n-n-n-n John_Edwards 6 8689 October 29, 2013 03:05 PM by Clif code modifies after project checked out from SVN Venkata 2 5586 October 28, 2013 06:18 PM by Venkata Best Practices: Source Control for iWay Channels Rangaprasad 5 7119 October 21, 2013 04:34 AM by Srii Creating Active Dashboards from multiple “Master files” Vikrantsabari88 1 5541 October 01, 2013 09:02 AM by Dave laod is taking more than 17 hours Vikrantsabari88 1 6434 September 30, 2013 01:58 PM by Clif Function: Lookup_MFD Meena 3 6370 September 24, 2013 01:35 PM by Clif [SOLVED] Using MERGE n a DM procedure ddornan 2 8683 September 24, 2013 07:53 AM by ddornan [SOLVED]executing a foc procedure using remote server node FOCUS393 1 6027 September 23, 2013 02:49 PM by FOCUS393 [CASE-OPENED] Properties File Reference In SREG ABailey 2 6095 September 13, 2013 08:51 AM by Srii How to kill the Process Flow? Praveen Kumar 1 5588 August 30, 2013 09:51 AM by gregb (Foc14006) SQL Translator Error Null join to table holdtable() Vikrantsabari88 1 6231 August 26, 2013 02:31 PM by Clif Runtime variable ABailey 1 5666 August 23, 2013 09:18 AM by jgelona SQL Join and NULL Values Dan Pinault 5 24743 August 15, 2013 10:10 AM by Clif Property and Reference are disabled in my Field properties? Praveen Kumar 1 5307 August 14, 2013 01:42 PM by <Kathryn Henning> DataMigrator cmrun 64-bit benicely 1 6229 August 12, 2013 11:13 AM by Clif Can't create Data/Process flow in DMC Praveen Kumar 1 5742 August 11, 2013 12:24 PM by dhagen Can't find Adapters to connect in Iway DMC 8.0.0.3 Praveen Kumar 1 6056 August 05, 2013 03:28 AM by Twanette DataMigrator Workspace Environment Jami 1 5428 July 30, 2013 01:17 PM by <Kathryn Henning> How to run pflow by using XDPFlowAgent tropwind 4 5997 July 24, 2013 05:18 PM by tropwind create table for sql server in data migrator using stored proc Gee68 1 6411 July 22, 2013 05:07 PM by Clif Input on Best Practices for Sharing Application Folder ddornan 1 5360 July 19, 2013 05:10 AM by Martin vK [SOLVED] [CASE-OPENED] use _concat to add a prefix in iit or service manager Gee68 3 6665 July 18, 2013 03:41 PM by Gee68 [SOLVED] DMC Variables - Job ID ddornan 3 8898 July 16, 2013 01:55 PM by ddornan [CASE-OPENED] DB2 bulkload converts empty strings into null value Martin vK 1 6551 July 15, 2013 12:32 PM by <Kathryn Henning> [SOLVED] Another SCD Question ddornan 1 4990 July 11, 2013 06:26 PM by ddornan [CASE-OPENED] DB2 bulkload truncates char fields with double quotes Martin vK 1 6430 July 11, 2013 10:52 AM by Clif Best way to ignore a surrogate key when loading a table through a flow D Luchinski 4 15768 July 08, 2013 09:53 AM by Clif invoke data migrator from java <Ranga> 8 11811 July 04, 2013 09:17 AM by dhagen features of Data migrator version 7702 and 7705 satish chennupati 1 5434 June 28, 2013 01:30 PM by Clif Scheduled Events and Scheduler Log vaayu 1 5368 June 26, 2013 06:42 PM by <Kathryn Henning> start/stop deployments using command line mntnman 5 9889 June 20, 2013 09:03 AM by Srii [workaround] [solved] How do you calculate working days in data migrator Gee68 1 4954 June 20, 2013 06:45 AM by FrankDutch Insert Record From Memory -- What Happens if Record Exists? John_Edwards 2 5577 June 19, 2013 08:25 AM by Clif Data Migrator Table Unions (row limit?) cs_source 2 6050 June 18, 2013 10:11 AM by Clif Object is in a zombie state Koby1Kanoby 2 9729 June 11, 2013 03:00 PM by Koby1Kanoby [SOLVED] How do I embed a carriage return in the text of my iWay Constant object Phil DeBusk 2 5698 June 11, 2013 02:54 PM by Phil DeBusk [SOLVED] How to strip quotes from XML Phil DeBusk 3 15081 June 11, 2013 02:49 PM by Phil DeBusk [SOLVED] qval() quote always returns two single quotes back to back! Phil DeBusk 2 5763 June 11, 2013 02:48 PM by Phil DeBusk [CLOSED] Data Management - Target question cs_source 1 5146 May 29, 2013 09:18 AM by Clif [CASE-OPENED] Data Migrator crashing hard -- ipipesnd error: 232. Anyone seen this? John_Edwards 2 9810 May 23, 2013 02:47 PM by susannah [CLOSED] DB2 Advice Required -- Row Change Timestamp John_Edwards 1 5220 May 23, 2013 12:07 PM by Clif [SOVLED] I am getting "invalid character value for cast specification" <We_Focus> 4 20695 May 16, 2013 11:16 PM by vaayu [SOLVED] iWay Srvc Mgr-Cannot Truncate Table then Insert Records in same process flow Phil DeBusk 1 5340 May 15, 2013 06:46 PM by Phil DeBusk [CASE-OPENED] Need Help To Call runtime value in Join Object Maruthu 1 4973 May 13, 2013 01:36 PM by <Kathryn Henning> [SOLVED]Transform looping Charles Maheu 5 6056 May 07, 2013 12:01 PM by Charles Maheu [CASE-OPENED] DQC Grouping Issue ABailey 1 4922 May 01, 2013 07:32 PM by <Kathryn Henning> [CLOSED] Active Log and Statistic on DM Carlos Da Costa 1 5204 April 15, 2013 04:52 PM by Clif [CLOSED] Do we have any problem in "IN FILE" concept (where condition) Santhu 2 5705 April 15, 2013 09:19 AM by jgelona [CASE-OPENED] CLOB data length limitation in DataMigrator sarma_433 2 5902 April 13, 2013 01:53 PM by sarma_433 [CLOSED] && variables in SQL Flow Martin vK 3 7423 April 12, 2013 12:33 PM by Martin vK Webinars: Getting Data Ready for WebFOCUS on 4/20, Bad Data Tax Tips on 04/11 Kerry 1 5551 April 08, 2013 02:55 PM by Kerry [CASE-OPENED] DB2 bulkload gives error with last column being character Martin vK 1 7837 April 04, 2013 10:33 AM by Clif [CLOSED] TRUNCATE TABLE in Data Migrator stored procedure AnnaR 4 8924 April 03, 2013 04:13 AM by Alan B [SOLVED] How to create a fixed width text file using DM Phil DeBusk 5 6992 March 29, 2013 10:49 AM by Phil DeBusk [SOLVED] How to culculate the rank value in DataMicgrator? jay sun 4 5991 March 28, 2013 04:37 AM by jay sun Writing to XML -- Can You Remove the "xmlns:xsi=http" Part? John_Edwards 1 6089 March 18, 2013 03:15 PM by Clif ETL Flow not reporting on truncated data AnnaR 2 10145 March 08, 2013 07:55 AM by dhagen Excel 2010 preparser Shirley 4 7204 February 26, 2013 04:13 PM by Shirley DQM date conversion in JDBC Reader Andrea Davis 1 6545 February 21, 2013 03:02 PM by Andrea Davis Custom Steps in Iway MDC jcrowder 1 5447 February 15, 2013 12:56 PM by Kerry SQL RIGHT FUNCTION USED IN SELECT STATEMENT AnnaR 3 12678 February 12, 2013 03:50 PM by Clif Maintain/Add records in FOUCS file Guang 2 5647 February 11, 2013 02:41 PM by Clif Passing variables to Plans in iWay MDC jcrowder 2 5594 February 05, 2013 05:02 PM by DBremer SQL Server indexes not being created using CREATE FILE D Luchinski 3 6405 February 01, 2013 02:42 PM by alzobjeck Email Services not sending email when parallel group is used ARP@SYS 3 5772 January 28, 2013 04:41 PM by ARP@SYS [RESOLVED] Input document cannot be empty or flat cgiuda 4 6508 January 10, 2013 12:17 PM by cgiuda Anyone using iWay on IBM i V7R1? cgiuda 2 5859 January 08, 2013 08:32 AM by wpoulin XSLT Data Migrator ray_In_Vancouver 1 5394 December 26, 2012 11:47 AM by Kerry [RESOLVED]Configure BI Object in iSM Shirley 2 5791 November 30, 2012 04:12 PM by Shirley Email Listener with Attachment TexasStingray 3 11506 November 27, 2012 06:21 PM by Shirley Can you publish to a specific configuration on a server? cgiuda 1 5024 November 16, 2012 03:56 PM by cgiuda Regex Inside Properties File benicely 2 9391 November 12, 2012 10:50 AM by benicely XFocus - Prior to Load Option Koby1Kanoby 4 5911 October 30, 2012 04:19 PM by Koby1Kanoby Zero loaded instead of integer values Chiranjeevi 6 6458 October 30, 2012 03:43 PM by Clif iWay 'subselect' problem jrh 4 6844 October 30, 2012 11:30 AM by jrh Uploading excel files and archiving them with datetimestamp MartijnZ 1 5509 October 26, 2012 12:43 PM by dhagen iWay Web Service Shirley 2 5609 October 22, 2012 06:36 PM by Shirley REGARDING REMOVING SPECIAL CHARACTERS IN DATAMIGRATOR WHILE LOADING DATA INTO ORACLE deepak85 3 7329 October 22, 2012 12:05 PM by Dan Satchell End date is not updated in SCD1 logic Chiranjeevi 1 5063 October 19, 2012 09:56 AM by Clif Making JDBC Connections to SQL Server 2012 RonnieUg 2 6931 October 17, 2012 09:36 PM by Charles Maheu Oracle CDC in iWay Ramanathan 1 5635 October 15, 2012 02:21 PM by Kerry FOC000 ERROR MESSAGE TEXT MISSING: xxxxx Ian Dalton 3 8070 October 12, 2012 07:31 AM by Ian Dalton 837 file format RonnieUg 2 5846 October 09, 2012 03:44 PM by RonnieUg impersonation using XDPrincipalAgent Big Daddy 1 4653 October 09, 2012 01:43 PM by Kerry [RESOLVED]iSM data migrator ETL object Shirley 2 5482 October 05, 2012 05:13 PM by Shirley iWay Application Business Agent cokeyng 0 4520 October 05, 2012 03:55 PM iway service manager FTPS Gee68 2 5562 October 05, 2012 11:48 AM by ray_In_Vancouver Couldnot find Dataflow and processflow ARP@SYS 1 4695 September 28, 2012 09:31 AM by Clif Datamigrator newbie questions ferran 8 12173 September 27, 2012 03:22 PM by Clif Email Adepter ray_In_Vancouver 14 13498 September 26, 2012 09:07 AM by benicely [SOLVED] Calling an Oracle procedure in Data Migrator dballest 14 15393 September 26, 2012 07:48 AM by janaki_senthil Upcoming Webinar: iWay Data Profiler and Data Quality Update Kerry 1 5006 September 24, 2012 12:27 PM by Kerry Accelerate XML Write Speed? John_Edwards 4 5513 September 20, 2012 03:43 PM by John_Edwards iSM Integration with C/C++/C# Programs AK 1 4886 September 20, 2012 03:12 PM by Kerry