ETL and Data Integration tools - Modern ETL software for everyone

HomeForum

Welcome, Guest

Records inserted, table truncated, ghost records updated

(1 viewing) (1) Guest

Data Warehousing and Data integration

Reply Topic

TOPIC: Records inserted, table truncated, ghost records updated

JMetcalf OFFLINE Junior Boarder Posts: 35 Karma: 0	ETL Ent version4.2.6.6 (trial) I have a transform connected to a view the selects the top 100 of a SQL server data set. I am pushing these to a data warehouse. The transform ran. Then I tweaked the table and truncated it. The transform now inserts only 19 records, and updates 81. Update Key is checked.
	Reply Quote

admin OFFLINE Moderator Posts: 2183 Karma: 12	To be honest I do not understand what the problem is. Like I was expected that but it did this. Mike
	Reply Quote