1 / 56

DataMigrator Update Release 7.7.04

DataMigrator Update Release 7.7.04. Clif Kranish Director, Data Management Division. Data Management Console. Autosave. Edit Undo / Redo Specify limit for Flows and Synonyms. Edit - Undo / Redo Synonym and Flow editors . Tabbed Windows. Tab Groups Window > New Horizontal Tab Group.

quinta
Download Presentation

DataMigrator Update Release 7.7.04

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DataMigrator UpdateRelease 7.7.04 Clif KranishDirector, Data Management Division

  2. Data Management Console

  3. Autosave

  4. Edit Undo / RedoSpecify limit for Flows and Synonyms

  5. Edit - Undo / RedoSynonym and Flow editors

  6. Tabbed Windows

  7. Tab GroupsWindow > New Horizontal Tab Group

  8. Tab GroupsView two Data Profiling reports at once

  9. Data ProfilingCount

  10. Browser See all files in application directories

  11. Edit flat files

  12. Edit XML and XSD

  13. Print Preview

  14. Data Flows and Process Flows Partitioning SUB QUERIES Database Default Values

  15. Quick CopyGenerates Data Flow for entire table(s)

  16. For source with a numeric key columnAutomatic partitioning

  17. Automatic PartitioningGenerated Process Flow

  18. Automatic PartitioningParameter Passing

  19. Automatic PartitioningLog

  20. WHERE FilterNew SQL Operators

  21. Function AssistEXISTS

  22. Function AssistSUBQUERY

  23. Sub Query In Select List

  24. Database Default ValuesCOUNTRY default is ‘USA’

  25. Database DefaultsTransformations – No value assigned to COUNTRY

  26. Database Defaults Database defaults are now respected. But for NOT NULL columns without a default… You must assign a value!

  27. Set VariablesHelp for Statistical Variables

  28. Slowly Changing Dimensions Indexes Timestamps

  29. Slowly Changing DimensionsType I changes – Overwrite History Source Newcomb, Jan Dimension Newcomb, Jan

  30. Slowly Changing DimensionsType II changes – Record History Source LA Dimension 06-Jun-12

  31. Faster Load with Indexes in RDBMS Tables

  32. Index Fields EditorAcceptIndex on REPNO (key column)

  33. IndexesAdded Index on REPNO and EMPID

  34. IndexesRecreate Database Table

  35. IndexesAs seen in RDBMS

  36. Slowly Changing Dimension tablesDatetime / Timestamp for begin / end dates

  37. Scheduler • Start/Stop Scanning • Manage Scheduled Flows • Run When Server Starts

  38. SchedulerStart / Stop Scanning and Scheduler Agents

  39. Scheduler AgentsSelect and Activate / Deactivate

  40. Real Time CDC Log or File Listener Source

  41. Scheduled FlowsRun when server starts

  42. New and Improved Adapters • Load • Salesforce • AddressDoctor • JSON • Hadoop and Hive

  43. Improved Adapters Concurrent fastload inserts Teradata Parallel Transport API Change Data Capture

  44. Salesforce.comQuery Adapter based on SOQL

  45. Salesforce.comCreate Cluster Join – using relationships in data model

  46. AddressDoctorSynonym for procedure created at configuration

  47. AddressDoctorPass parameters in JOIN

  48. AddressDoctorCleansed Addresses

  49. JSONJavaScript Object Notation

  50. JSONSynonym created using document itself

More Related