Hi da-zero,

I had tried the "redirect row" and "ignore failure" approach but still my IDs didn't transform correctly. Please find my 2 result scenarios attached.

My ultimate goal is to...

Hi Phil,

I had some problems here after applying the Lookup Transformation when I want to do partial mapping.

For example, if I have other few hundreds of PRODUCT code which I...

Hi Phil,

I still encounter some problems with the lookup table where by it still can't transform my data from source file into my fact table. Please refer to my screenshot...

da-zero (4/13/2010)

---

Add a Derived Column Transformation to your data flow.

Select "Replace 'EntityID'" in the Derived Column.

Then use the following expression:

(EntityID == "AAA") ? "BBB" : EntityID

This will replace all AAA...

Paul White NZ (4/6/2010)

---

yingchai (4/6/2010)

---

I'm not so concern about the I/O performance as I predict the Cost fact table will grow to approximately 1 mil records in 10 years. Currently,...

Hi Jeff,

I had sorted out the update portion. The code should look like this:

update S set

cost = C.cost

FROM factcosts2 S

CROSS

APPLY (

...

Paul White NZ (4/5/2010)

---

:ermm: Not a running total problem.

CREATE TABLE Sample1

(

product_id CHAR(7) NOT NULL,

...

Hi Paul and Jeff,

The actual data in the period column which shows the output as Jan.09 is actually a datetime datatype which stores "1/1/2009 12:00:00 AM". But when we display...

Paul White NZ (4/5/2010)

---

:ermm: Not a running total problem.

DECLARE @Sample

TABLE (

product_id CHAR(7) NOT NULL,

...