Topic Topic Starter Replies Views Last Post [CASE-OPENED] Creating Log and statistical Tables - Data Migrator Balaji 1 6170 November 22, 2013 07:29 PM by <Kathryn Henning> Using statistical variables in the Data flow to load a log table Balaji 4 6060 November 22, 2013 10:31 AM by Clif [CASE-OPENED] Command Task in Iway Data Migrator Balaji 5 7113 November 22, 2013 10:28 AM by Clif November 14th Webinar: The Power of MDM in a Big Data World Kathleen Butler 0 4731 November 12, 2013 11:45 PM (SOLVED) Unable to Pass Parameters in CMASAP Shruthi Joshi 8 12527 November 11, 2013 11:09 AM by Clif DATEADD but in Focus Variable? cs_source 5 9232 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 8535 October 29, 2013 03:05 PM by Clif code modifies after project checked out from SVN Venkata 2 5477 October 28, 2013 06:18 PM by Venkata Best Practices: Source Control for iWay Channels Rangaprasad 5 7014 October 21, 2013 04:34 AM by Srii Creating Active Dashboards from multiple “Master files” Vikrantsabari88 1 5476 October 01, 2013 09:02 AM by Dave laod is taking more than 17 hours Vikrantsabari88 1 6370 September 30, 2013 01:58 PM by Clif Function: Lookup_MFD Meena 3 6246 September 24, 2013 01:35 PM by Clif [SOLVED] Using MERGE n a DM procedure ddornan 2 8611 September 24, 2013 07:53 AM by ddornan [SOLVED]executing a foc procedure using remote server node FOCUS393 1 5944 September 23, 2013 02:49 PM by FOCUS393 [CASE-OPENED] Properties File Reference In SREG ABailey 2 5976 September 13, 2013 08:51 AM by Srii How to kill the Process Flow? Praveen Kumar 1 5522 August 30, 2013 09:51 AM by gregb (Foc14006) SQL Translator Error Null join to table holdtable() Vikrantsabari88 1 6142 August 26, 2013 02:31 PM by Clif Runtime variable ABailey 1 5587 August 23, 2013 09:18 AM by jgelona SQL Join and NULL Values Dan Pinault 5 24571 August 15, 2013 10:10 AM by Clif Property and Reference are disabled in my Field properties? Praveen Kumar 1 5254 August 14, 2013 01:42 PM by <Kathryn Henning> DataMigrator cmrun 64-bit benicely 1 6149 August 12, 2013 11:13 AM by Clif Can't create Data/Process flow in DMC Praveen Kumar 1 5674 August 11, 2013 12:24 PM by dhagen Can't find Adapters to connect in Iway DMC 8.0.0.3 Praveen Kumar 1 5997 August 05, 2013 03:28 AM by Twanette DataMigrator Workspace Environment Jami 1 5345 July 30, 2013 01:17 PM by <Kathryn Henning> How to run pflow by using XDPFlowAgent tropwind 4 5917 July 24, 2013 05:18 PM by tropwind create table for sql server in data migrator using stored proc Gee68 1 6329 July 22, 2013 05:07 PM by Clif Input on Best Practices for Sharing Application Folder ddornan 1 5232 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 6575 July 18, 2013 03:41 PM by Gee68 [SOLVED] DMC Variables - Job ID ddornan 3 8773 July 16, 2013 01:55 PM by ddornan [CASE-OPENED] DB2 bulkload converts empty strings into null value Martin vK 1 6480 July 15, 2013 12:32 PM by <Kathryn Henning> [SOLVED] Another SCD Question ddornan 1 4895 July 11, 2013 06:26 PM by ddornan [CASE-OPENED] DB2 bulkload truncates char fields with double quotes Martin vK 1 6323 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 15598 July 08, 2013 09:53 AM by Clif invoke data migrator from java <Ranga> 8 11675 July 04, 2013 09:17 AM by dhagen features of Data migrator version 7702 and 7705 satish chennupati 1 5380 June 28, 2013 01:30 PM by Clif Scheduled Events and Scheduler Log vaayu 1 5306 June 26, 2013 06:42 PM by <Kathryn Henning> start/stop deployments using command line mntnman 5 9774 June 20, 2013 09:03 AM by Srii [workaround] [solved] How do you calculate working days in data migrator Gee68 1 4875 June 20, 2013 06:45 AM by FrankDutch Insert Record From Memory -- What Happens if Record Exists? John_Edwards 2 5457 June 19, 2013 08:25 AM by Clif Data Migrator Table Unions (row limit?) cs_source 2 5937 June 18, 2013 10:11 AM by Clif Object is in a zombie state Koby1Kanoby 2 9587 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 5621 June 11, 2013 02:54 PM by Phil DeBusk [SOLVED] How to strip quotes from XML Phil DeBusk 3 14947 June 11, 2013 02:49 PM by Phil DeBusk [SOLVED] qval() quote always returns two single quotes back to back! Phil DeBusk 2 5692 June 11, 2013 02:48 PM by Phil DeBusk [CLOSED] Data Management - Target question cs_source 1 5075 May 29, 2013 09:18 AM by Clif [CASE-OPENED] Data Migrator crashing hard -- ipipesnd error: 232. Anyone seen this? John_Edwards 2 9739 May 23, 2013 02:47 PM by susannah [CLOSED] DB2 Advice Required -- Row Change Timestamp John_Edwards 1 5146 May 23, 2013 12:07 PM by Clif [SOVLED] I am getting "invalid character value for cast specification" <We_Focus> 4 20538 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 5259 May 15, 2013 06:46 PM by Phil DeBusk [CASE-OPENED] Need Help To Call runtime value in Join Object Maruthu 1 4912 May 13, 2013 01:36 PM by <Kathryn Henning> [SOLVED]Transform looping Charles Maheu 5 5940 May 07, 2013 12:01 PM by Charles Maheu [CASE-OPENED] DQC Grouping Issue ABailey 1 4876 May 01, 2013 07:32 PM by <Kathryn Henning> [CLOSED] Active Log and Statistic on DM Carlos Da Costa 1 5147 April 15, 2013 04:52 PM by Clif [CLOSED] Do we have any problem in "IN FILE" concept (where condition) Santhu 2 5583 April 15, 2013 09:19 AM by jgelona [CASE-OPENED] CLOB data length limitation in DataMigrator sarma_433 2 5805 April 13, 2013 01:53 PM by sarma_433 [CLOSED] && variables in SQL Flow Martin vK 3 7322 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 5462 April 08, 2013 02:55 PM by Kerry [CASE-OPENED] DB2 bulkload gives error with last column being character Martin vK 1 7742 April 04, 2013 10:33 AM by Clif [CLOSED] TRUNCATE TABLE in Data Migrator stored procedure AnnaR 4 8806 April 03, 2013 04:13 AM by Alan B [SOLVED] How to create a fixed width text file using DM Phil DeBusk 5 6825 March 29, 2013 10:49 AM by Phil DeBusk [SOLVED] How to culculate the rank value in DataMicgrator? jay sun 4 5894 March 28, 2013 04:37 AM by jay sun Writing to XML -- Can You Remove the "xmlns:xsi=http" Part? John_Edwards 1 6007 March 18, 2013 03:15 PM by Clif ETL Flow not reporting on truncated data AnnaR 2 10037 March 08, 2013 07:55 AM by dhagen Excel 2010 preparser Shirley 4 7101 February 26, 2013 04:13 PM by Shirley DQM date conversion in JDBC Reader Andrea Davis 1 6492 February 21, 2013 03:02 PM by Andrea Davis Custom Steps in Iway MDC jcrowder 1 5356 February 15, 2013 12:56 PM by Kerry SQL RIGHT FUNCTION USED IN SELECT STATEMENT AnnaR 3 12581 February 12, 2013 03:50 PM by Clif Maintain/Add records in FOUCS file Guang 2 5544 February 11, 2013 02:41 PM by Clif Passing variables to Plans in iWay MDC jcrowder 2 5467 February 05, 2013 05:02 PM by DBremer SQL Server indexes not being created using CREATE FILE D Luchinski 3 6257 February 01, 2013 02:42 PM by alzobjeck Email Services not sending email when parallel group is used ARP@SYS 3 5695 January 28, 2013 04:41 PM by ARP@SYS [RESOLVED] Input document cannot be empty or flat cgiuda 4 6417 January 10, 2013 12:17 PM by cgiuda Anyone using iWay on IBM i V7R1? cgiuda 2 5716 January 08, 2013 08:32 AM by wpoulin XSLT Data Migrator ray_In_Vancouver 1 5335 December 26, 2012 11:47 AM by Kerry [RESOLVED]Configure BI Object in iSM Shirley 2 5716 November 30, 2012 04:12 PM by Shirley Email Listener with Attachment TexasStingray 3 11430 November 27, 2012 06:21 PM by Shirley Can you publish to a specific configuration on a server? cgiuda 1 4934 November 16, 2012 03:56 PM by cgiuda Regex Inside Properties File benicely 2 9213 November 12, 2012 10:50 AM by benicely XFocus - Prior to Load Option Koby1Kanoby 4 5798 October 30, 2012 04:19 PM by Koby1Kanoby Zero loaded instead of integer values Chiranjeevi 6 6327 October 30, 2012 03:43 PM by Clif iWay 'subselect' problem jrh 4 6754 October 30, 2012 11:30 AM by jrh Uploading excel files and archiving them with datetimestamp MartijnZ 1 5453 October 26, 2012 12:43 PM by dhagen iWay Web Service Shirley 2 5544 October 22, 2012 06:36 PM by Shirley REGARDING REMOVING SPECIAL CHARACTERS IN DATAMIGRATOR WHILE LOADING DATA INTO ORACLE deepak85 3 7191 October 22, 2012 12:05 PM by Dan Satchell End date is not updated in SCD1 logic Chiranjeevi 1 5004 October 19, 2012 09:56 AM by Clif Making JDBC Connections to SQL Server 2012 RonnieUg 2 6790 October 17, 2012 09:36 PM by Charles Maheu Oracle CDC in iWay Ramanathan 1 5587 October 15, 2012 02:21 PM by Kerry FOC000 ERROR MESSAGE TEXT MISSING: xxxxx Ian Dalton 3 7938 October 12, 2012 07:31 AM by Ian Dalton 837 file format RonnieUg 2 5785 October 09, 2012 03:44 PM by RonnieUg impersonation using XDPrincipalAgent Big Daddy 1 4604 October 09, 2012 01:43 PM by Kerry [RESOLVED]iSM data migrator ETL object Shirley 2 5415 October 05, 2012 05:13 PM by Shirley iWay Application Business Agent cokeyng 0 4478 October 05, 2012 03:55 PM iway service manager FTPS Gee68 2 5499 October 05, 2012 11:48 AM by ray_In_Vancouver Couldnot find Dataflow and processflow ARP@SYS 1 4615 September 28, 2012 09:31 AM by Clif Datamigrator newbie questions ferran 8 12014 September 27, 2012 03:22 PM by Clif Email Adepter ray_In_Vancouver 14 13216 September 26, 2012 09:07 AM by benicely [SOLVED] Calling an Oracle procedure in Data Migrator dballest 14 15141 September 26, 2012 07:48 AM by janaki_senthil Upcoming Webinar: iWay Data Profiler and Data Quality Update Kerry 1 4951 September 24, 2012 12:27 PM by Kerry Accelerate XML Write Speed? John_Edwards 4 5425 September 20, 2012 03:43 PM by John_Edwards iSM Integration with C/C++/C# Programs AK 1 4799 September 20, 2012 03:12 PM by Kerry