Topic Topic Starter Replies Views Last Post [CASE-OPENED] Creating Log and statistical Tables - Data Migrator Balaji 1 6187 November 22, 2013 07:29 PM by <Kathryn Henning> Using statistical variables in the Data flow to load a log table Balaji 4 6091 November 22, 2013 10:31 AM by Clif [CASE-OPENED] Command Task in Iway Data Migrator Balaji 5 7153 November 22, 2013 10:28 AM by Clif November 14th Webinar: The Power of MDM in a Big Data World Kathleen Butler 0 4744 November 12, 2013 11:45 PM (SOLVED) Unable to Pass Parameters in CMASAP Shruthi Joshi 8 12564 November 11, 2013 11:09 AM by Clif DATEADD but in Focus Variable? cs_source 5 9270 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 8572 October 29, 2013 03:05 PM by Clif code modifies after project checked out from SVN Venkata 2 5499 October 28, 2013 06:18 PM by Venkata Best Practices: Source Control for iWay Channels Rangaprasad 5 7043 October 21, 2013 04:34 AM by Srii Creating Active Dashboards from multiple “Master files” Vikrantsabari88 1 5491 October 01, 2013 09:02 AM by Dave laod is taking more than 17 hours Vikrantsabari88 1 6383 September 30, 2013 01:58 PM by Clif Function: Lookup_MFD Meena 3 6274 September 24, 2013 01:35 PM by Clif [SOLVED] Using MERGE n a DM procedure ddornan 2 8630 September 24, 2013 07:53 AM by ddornan [SOLVED]executing a foc procedure using remote server node FOCUS393 1 5958 September 23, 2013 02:49 PM by FOCUS393 [CASE-OPENED] Properties File Reference In SREG ABailey 2 6001 September 13, 2013 08:51 AM by Srii How to kill the Process Flow? Praveen Kumar 1 5538 August 30, 2013 09:51 AM by gregb (Foc14006) SQL Translator Error Null join to table holdtable() Vikrantsabari88 1 6163 August 26, 2013 02:31 PM by Clif Runtime variable ABailey 1 5605 August 23, 2013 09:18 AM by jgelona SQL Join and NULL Values Dan Pinault 5 24603 August 15, 2013 10:10 AM by Clif Property and Reference are disabled in my Field properties? Praveen Kumar 1 5266 August 14, 2013 01:42 PM by <Kathryn Henning> DataMigrator cmrun 64-bit benicely 1 6166 August 12, 2013 11:13 AM by Clif Can't create Data/Process flow in DMC Praveen Kumar 1 5696 August 11, 2013 12:24 PM by dhagen Can't find Adapters to connect in Iway DMC 8.0.0.3 Praveen Kumar 1 6011 August 05, 2013 03:28 AM by Twanette DataMigrator Workspace Environment Jami 1 5363 July 30, 2013 01:17 PM by <Kathryn Henning> How to run pflow by using XDPFlowAgent tropwind 4 5939 July 24, 2013 05:18 PM by tropwind create table for sql server in data migrator using stored proc Gee68 1 6348 July 22, 2013 05:07 PM by Clif Input on Best Practices for Sharing Application Folder ddornan 1 5267 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 6593 July 18, 2013 03:41 PM by Gee68 [SOLVED] DMC Variables - Job ID ddornan 3 8802 July 16, 2013 01:55 PM by ddornan [CASE-OPENED] DB2 bulkload converts empty strings into null value Martin vK 1 6500 July 15, 2013 12:32 PM by <Kathryn Henning> [SOLVED] Another SCD Question ddornan 1 4911 July 11, 2013 06:26 PM by ddornan [CASE-OPENED] DB2 bulkload truncates char fields with double quotes Martin vK 1 6347 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 15635 July 08, 2013 09:53 AM by Clif invoke data migrator from java <Ranga> 8 11708 July 04, 2013 09:17 AM by dhagen features of Data migrator version 7702 and 7705 satish chennupati 1 5392 June 28, 2013 01:30 PM by Clif Scheduled Events and Scheduler Log vaayu 1 5325 June 26, 2013 06:42 PM by <Kathryn Henning> start/stop deployments using command line mntnman 5 9804 June 20, 2013 09:03 AM by Srii [workaround] [solved] How do you calculate working days in data migrator Gee68 1 4894 June 20, 2013 06:45 AM by FrankDutch Insert Record From Memory -- What Happens if Record Exists? John_Edwards 2 5480 June 19, 2013 08:25 AM by Clif Data Migrator Table Unions (row limit?) cs_source 2 5956 June 18, 2013 10:11 AM by Clif Object is in a zombie state Koby1Kanoby 2 9631 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 5638 June 11, 2013 02:54 PM by Phil DeBusk [SOLVED] How to strip quotes from XML Phil DeBusk 3 14969 June 11, 2013 02:49 PM by Phil DeBusk [SOLVED] qval() quote always returns two single quotes back to back! Phil DeBusk 2 5709 June 11, 2013 02:48 PM by Phil DeBusk [CLOSED] Data Management - Target question cs_source 1 5092 May 29, 2013 09:18 AM by Clif [CASE-OPENED] Data Migrator crashing hard -- ipipesnd error: 232. Anyone seen this? John_Edwards 2 9757 May 23, 2013 02:47 PM by susannah [CLOSED] DB2 Advice Required -- Row Change Timestamp John_Edwards 1 5164 May 23, 2013 12:07 PM by Clif [SOVLED] I am getting "invalid character value for cast specification" <We_Focus> 4 20583 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 5278 May 15, 2013 06:46 PM by Phil DeBusk [CASE-OPENED] Need Help To Call runtime value in Join Object Maruthu 1 4928 May 13, 2013 01:36 PM by <Kathryn Henning> [SOLVED]Transform looping Charles Maheu 5 5969 May 07, 2013 12:01 PM by Charles Maheu [CASE-OPENED] DQC Grouping Issue ABailey 1 4888 May 01, 2013 07:32 PM by <Kathryn Henning> [CLOSED] Active Log and Statistic on DM Carlos Da Costa 1 5162 April 15, 2013 04:52 PM by Clif [CLOSED] Do we have any problem in "IN FILE" concept (where condition) Santhu 2 5609 April 15, 2013 09:19 AM by jgelona [CASE-OPENED] CLOB data length limitation in DataMigrator sarma_433 2 5827 April 13, 2013 01:53 PM by sarma_433 [CLOSED] && variables in SQL Flow Martin vK 3 7348 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 5478 April 08, 2013 02:55 PM by Kerry [CASE-OPENED] DB2 bulkload gives error with last column being character Martin vK 1 7763 April 04, 2013 10:33 AM by Clif [CLOSED] TRUNCATE TABLE in Data Migrator stored procedure AnnaR 4 8847 April 03, 2013 04:13 AM by Alan B [SOLVED] How to create a fixed width text file using DM Phil DeBusk 5 6857 March 29, 2013 10:49 AM by Phil DeBusk [SOLVED] How to culculate the rank value in DataMicgrator? jay sun 4 5921 March 28, 2013 04:37 AM by jay sun Writing to XML -- Can You Remove the "xmlns:xsi=http" Part? John_Edwards 1 6025 March 18, 2013 03:15 PM by Clif ETL Flow not reporting on truncated data AnnaR 2 10059 March 08, 2013 07:55 AM by dhagen Excel 2010 preparser Shirley 4 7127 February 26, 2013 04:13 PM by Shirley DQM date conversion in JDBC Reader Andrea Davis 1 6506 February 21, 2013 03:02 PM by Andrea Davis Custom Steps in Iway MDC jcrowder 1 5370 February 15, 2013 12:56 PM by Kerry SQL RIGHT FUNCTION USED IN SELECT STATEMENT AnnaR 3 12608 February 12, 2013 03:50 PM by Clif Maintain/Add records in FOUCS file Guang 2 5565 February 11, 2013 02:41 PM by Clif Passing variables to Plans in iWay MDC jcrowder 2 5487 February 05, 2013 05:02 PM by DBremer SQL Server indexes not being created using CREATE FILE D Luchinski 3 6285 February 01, 2013 02:42 PM by alzobjeck Email Services not sending email when parallel group is used ARP@SYS 3 5714 January 28, 2013 04:41 PM by ARP@SYS [RESOLVED] Input document cannot be empty or flat cgiuda 4 6447 January 10, 2013 12:17 PM by cgiuda Anyone using iWay on IBM i V7R1? cgiuda 2 5737 January 08, 2013 08:32 AM by wpoulin XSLT Data Migrator ray_In_Vancouver 1 5350 December 26, 2012 11:47 AM by Kerry [RESOLVED]Configure BI Object in iSM Shirley 2 5736 November 30, 2012 04:12 PM by Shirley Email Listener with Attachment TexasStingray 3 11449 November 27, 2012 06:21 PM by Shirley Can you publish to a specific configuration on a server? cgiuda 1 4953 November 16, 2012 03:56 PM by cgiuda Regex Inside Properties File benicely 2 9265 November 12, 2012 10:50 AM by benicely XFocus - Prior to Load Option Koby1Kanoby 4 5832 October 30, 2012 04:19 PM by Koby1Kanoby Zero loaded instead of integer values Chiranjeevi 6 6356 October 30, 2012 03:43 PM by Clif iWay 'subselect' problem jrh 4 6774 October 30, 2012 11:30 AM by jrh Uploading excel files and archiving them with datetimestamp MartijnZ 1 5467 October 26, 2012 12:43 PM by dhagen iWay Web Service Shirley 2 5564 October 22, 2012 06:36 PM by Shirley REGARDING REMOVING SPECIAL CHARACTERS IN DATAMIGRATOR WHILE LOADING DATA INTO ORACLE deepak85 3 7218 October 22, 2012 12:05 PM by Dan Satchell End date is not updated in SCD1 logic Chiranjeevi 1 5020 October 19, 2012 09:56 AM by Clif Making JDBC Connections to SQL Server 2012 RonnieUg 2 6813 October 17, 2012 09:36 PM by Charles Maheu Oracle CDC in iWay Ramanathan 1 5600 October 15, 2012 02:21 PM by Kerry FOC000 ERROR MESSAGE TEXT MISSING: xxxxx Ian Dalton 3 7963 October 12, 2012 07:31 AM by Ian Dalton 837 file format RonnieUg 2 5802 October 09, 2012 03:44 PM by RonnieUg impersonation using XDPrincipalAgent Big Daddy 1 4616 October 09, 2012 01:43 PM by Kerry [RESOLVED]iSM data migrator ETL object Shirley 2 5434 October 05, 2012 05:13 PM by Shirley iWay Application Business Agent cokeyng 0 4486 October 05, 2012 03:55 PM iway service manager FTPS Gee68 2 5516 October 05, 2012 11:48 AM by ray_In_Vancouver Couldnot find Dataflow and processflow ARP@SYS 1 4631 September 28, 2012 09:31 AM by Clif Datamigrator newbie questions ferran 8 12045 September 27, 2012 03:22 PM by Clif Email Adepter ray_In_Vancouver 14 13285 September 26, 2012 09:07 AM by benicely [SOLVED] Calling an Oracle procedure in Data Migrator dballest 14 15201 September 26, 2012 07:48 AM by janaki_senthil Upcoming Webinar: iWay Data Profiler and Data Quality Update Kerry 1 4968 September 24, 2012 12:27 PM by Kerry Accelerate XML Write Speed? John_Edwards 4 5451 September 20, 2012 03:43 PM by John_Edwards iSM Integration with C/C++/C# Programs AK 1 4819 September 20, 2012 03:12 PM by Kerry