http://www.mydwbi.com/posts/list/3.page JForum - http://www.jforum.net Common Data Warehousing Requirements


1.01 Aggregation using Sorted Input

1.02 Tracking Dimension History

1.03 Constraint-Based Loading

1.04 Loading Incremental Updates

2.02 Tracking History and Current

2.19 Inserts or Updates





Transformation Techniques


1.05 Error Handling Strategy

1.06 Flat File Creation with Headers and Footers

1.07 Removing Duplicate Source Records

1.08 Transforming One Record into Multiple Records

2.05 Dynamic Caching

2.07 Sequence Generator Alternative

2.08 Streamline a Mapping with a Mapplet

2.09 Reusable Transformations (Customers)

2.12 Using a Sorter

2.14 Pipeline Partitioning Mapping Template

2.18 Using Update Strategy to Delete Rows

2.20 Loading Heterogenous Targets

2.21 Load Using External Procedure





Advanced Mapping Concepts


2.04 Aggregation Using Expression Transformation

2.06 Building a Parameter File

2.10 Best Build Logic

2.11 Comparing Values Between Records

3.01 Transaction control transformation

3.02 Data Cleansing using FirstLogic





Source-Specific Requirements


1.09 Processing VSAM Source Files

1.10 Processing Data from an XML Source

1.11 Joining a Flat File with a Relational Table





Industry-Specific Requirements


2.17 Loading SWIFT 942 Messages.htm

2.17 Loading SWIFT 950 Messages.htm
]]> http://www.mydwbi.com/posts/preList/30/83.page http://www.mydwbi.com/posts/preList/30/83.page GMT http://www.mydwbi.com/posts/preList/30/84.page http://www.mydwbi.com/posts/preList/30/84.page GMT http://www.mydwbi.com/posts/preList/30/85.page http://www.mydwbi.com/posts/preList/30/85.page GMT http://www.mydwbi.com/posts/preList/30/86.page http://www.mydwbi.com/posts/preList/30/86.page GMT http://www.mydwbi.com/posts/preList/30/87.page http://www.mydwbi.com/posts/preList/30/87.page GMT http://www.mydwbi.com/posts/preList/30/88.page http://www.mydwbi.com/posts/preList/30/88.page GMT http://www.mydwbi.com/posts/preList/30/89.page http://www.mydwbi.com/posts/preList/30/89.page GMT http://www.mydwbi.com/posts/preList/30/90.page http://www.mydwbi.com/posts/preList/30/90.page GMT http://www.mydwbi.com/posts/preList/30/91.page http://www.mydwbi.com/posts/preList/30/91.page GMT http://www.mydwbi.com/posts/preList/30/92.page http://www.mydwbi.com/posts/preList/30/92.page GMT http://www.mydwbi.com/posts/preList/30/93.page http://www.mydwbi.com/posts/preList/30/93.page GMT http://www.mydwbi.com/posts/preList/30/94.page http://www.mydwbi.com/posts/preList/30/94.page GMT http://www.mydwbi.com/posts/preList/30/95.page http://www.mydwbi.com/posts/preList/30/95.page GMT http://www.mydwbi.com/posts/preList/30/96.page http://www.mydwbi.com/posts/preList/30/96.page GMT http://www.mydwbi.com/posts/preList/30/97.page http://www.mydwbi.com/posts/preList/30/97.page GMT http://www.mydwbi.com/posts/preList/30/98.page http://www.mydwbi.com/posts/preList/30/98.page GMT http://www.mydwbi.com/posts/preList/30/99.page http://www.mydwbi.com/posts/preList/30/99.page GMT http://www.mydwbi.com/posts/preList/30/100.page http://www.mydwbi.com/posts/preList/30/100.page GMT http://www.mydwbi.com/posts/preList/30/101.page http://www.mydwbi.com/posts/preList/30/101.page GMT http://www.mydwbi.com/posts/preList/30/102.page http://www.mydwbi.com/posts/preList/30/102.page GMT http://www.mydwbi.com/posts/preList/30/103.page http://www.mydwbi.com/posts/preList/30/103.page GMT http://www.mydwbi.com/posts/preList/30/104.page http://www.mydwbi.com/posts/preList/30/104.page GMT http://www.mydwbi.com/posts/preList/30/105.page http://www.mydwbi.com/posts/preList/30/105.page GMT http://www.mydwbi.com/posts/preList/30/106.page http://www.mydwbi.com/posts/preList/30/106.page GMT http://www.mydwbi.com/posts/preList/30/108.page http://www.mydwbi.com/posts/preList/30/108.page GMT
:) :mrgreen:

恩,楼上人品不错!

这些mapping研究透了,informatica做一般的项目绝对没有问题.!!!]]> http://www.mydwbi.com/posts/preList/30/109.page http://www.mydwbi.com/posts/preList/30/109.page GMT http://www.mydwbi.com/posts/preList/30/136.page http://www.mydwbi.com/posts/preList/30/136.page GMT 有些貪心哦，呵呵]]> http://www.mydwbi.com/posts/preList/30/196.page http://www.mydwbi.com/posts/preList/30/196.page GMT
我顶！]]> http://www.mydwbi.com/posts/preList/30/220.page http://www.mydwbi.com/posts/preList/30/220.page GMT 哈哈哈哈，问世间灌水为何物，只让人看的头昏眼花]]> http://www.mydwbi.com/posts/preList/30/221.page http://www.mydwbi.com/posts/preList/30/221.page GMT http://www.mydwbi.com/posts/preList/30/304.page http://www.mydwbi.com/posts/preList/30/304.page GMT http://www.mydwbi.com/posts/preList/30/305.page http://www.mydwbi.com/posts/preList/30/305.page GMT http://www.mydwbi.com/posts/preList/30/368.page http://www.mydwbi.com/posts/preList/30/368.page GMT
这是本站的特色,也是自足之本,本站版主也都是业内高手,请多支持啊!!!!

]]> http://www.mydwbi.com/posts/preList/30/369.page http://www.mydwbi.com/posts/preList/30/369.page GMT http://www.mydwbi.com/posts/preList/30/765.page http://www.mydwbi.com/posts/preList/30/765.page GMT http://www.mydwbi.com/posts/preList/30/1064.page http://www.mydwbi.com/posts/preList/30/1064.page GMT http://www.mydwbi.com/posts/preList/30/1167.page http://www.mydwbi.com/posts/preList/30/1167.page GMT 运行这些mapping都对软件环境有什么要求？必须是MSSQL Server, CodePage1252么？

我的是INFA8.5+Oracle9.2(MS Windows Simplified Chinese)，可以用这些例子么？
谢谢
]]> http://www.mydwbi.com/posts/preList/30/1209.page http://www.mydwbi.com/posts/preList/30/1209.page GMT 不知道楼主是否有真实的Source,想实际跑一下]]> http://www.mydwbi.com/posts/preList/30/1216.page http://www.mydwbi.com/posts/preList/30/1216.page GMT It is really some real stuff, thanks very much for the host' contribution to the DW community. Even I stayed in Toronto, I would rather to reference these mappings.

Great, nice!

The first DW site I 've ever seen with such good stuffs.

Ike]]> http://www.mydwbi.com/posts/preList/30/1220.page http://www.mydwbi.com/posts/preList/30/1220.page GMT 运行这些mapping都对软件环境有什么要求？必须是MSSQL Server, CodePage1252么？

我的是INFA8.5+Oracle9.2(MS Windows Simplified Chinese)，可以用这些例子么？
谢谢
[/quote]

You have to try to import the V7 mappings to see the result. there's no limitation on what DB you use. what you need to create connection/ODBC to the DB you are going to work with.]]> http://www.mydwbi.com/posts/preList/30/1221.page http://www.mydwbi.com/posts/preList/30/1221.page GMT http://www.mydwbi.com/posts/preList/30/1443.page http://www.mydwbi.com/posts/preList/30/1443.page GMT http://www.mydwbi.com/posts/preList/30/1572.page http://www.mydwbi.com/posts/preList/30/1572.page GMT http://www.mydwbi.com/posts/preList/30/1649.page http://www.mydwbi.com/posts/preList/30/1649.page GMT 不错的资料!~
楼主辛苦了!~]]> http://www.mydwbi.com/posts/preList/30/1676.page http://www.mydwbi.com/posts/preList/30/1676.page GMT http://www.mydwbi.com/posts/preList/30/1776.page http://www.mydwbi.com/posts/preList/30/1776.page GMT http://www.mydwbi.com/posts/preList/30/2021.page http://www.mydwbi.com/posts/preList/30/2021.page GMT http://www.mydwbi.com/posts/preList/30/2022.page http://www.mydwbi.com/posts/preList/30/2022.page GMT http://www.mydwbi.com/posts/preList/30/2071.page http://www.mydwbi.com/posts/preList/30/2071.page GMT http://www.mydwbi.com/posts/preList/30/2072.page http://www.mydwbi.com/posts/preList/30/2072.page GMT http://www.mydwbi.com/posts/preList/30/2217.page http://www.mydwbi.com/posts/preList/30/2217.page GMT http://www.mydwbi.com/posts/preList/30/2268.page http://www.mydwbi.com/posts/preList/30/2268.page GMT
要是给导出个8的REP就更好啦。]]> http://www.mydwbi.com/posts/preList/30/2298.page http://www.mydwbi.com/posts/preList/30/2298.page GMT 不错的资料!~
楼主辛苦了!~[/quote]

哥们，是不是都已经导入到INFA中了，能否在reporsity一次导出个整合好的XML上传一下啊。

谢谢

虽然是这么好的东西，但也别让所有人都手软啊，呵呵]]> http://www.mydwbi.com/posts/preList/30/2318.page http://www.mydwbi.com/posts/preList/30/2318.page GMT
自己动手丰衣足食，还学会几个命令，8错8错！

咱给弄个集合版]]> http://www.mydwbi.com/posts/preList/30/2328.page http://www.mydwbi.com/posts/preList/30/2328.page GMT
自己动手丰衣足食，还学会几个命令，8错8错！

咱给弄个集合版[/quote]

]]> http://www.mydwbi.com/posts/preList/30/2329.page http://www.mydwbi.com/posts/preList/30/2329.page GMT http://www.mydwbi.com/posts/preList/30/2336.page http://www.mydwbi.com/posts/preList/30/2336.page GMT http://www.mydwbi.com/posts/preList/30/2602.page http://www.mydwbi.com/posts/preList/30/2602.page GMT http://www.mydwbi.com/posts/preList/30/2629.page http://www.mydwbi.com/posts/preList/30/2629.page GMT http://www.mydwbi.com/posts/preList/30/2697.page http://www.mydwbi.com/posts/preList/30/2697.page GMT http://www.mydwbi.com/posts/preList/30/2707.page http://www.mydwbi.com/posts/preList/30/2707.page GMT http://www.mydwbi.com/posts/preList/30/2782.page http://www.mydwbi.com/posts/preList/30/2782.page GMT http://www.mydwbi.com/posts/preList/30/2855.page http://www.mydwbi.com/posts/preList/30/2855.page GMT
自己动手丰衣足食，还学会几个命令，8错8错！

咱给弄个集合版[/quote]

多谢这位了。用了你的集合版一次性导成了。]]> http://www.mydwbi.com/posts/preList/30/2906.page http://www.mydwbi.com/posts/preList/30/2906.page GMT http://www.mydwbi.com/posts/preList/30/2914.page http://www.mydwbi.com/posts/preList/30/2914.page GMT http://www.mydwbi.com/posts/preList/30/2922.page http://www.mydwbi.com/posts/preList/30/2922.page GMT http://www.mydwbi.com/posts/preList/30/2969.page http://www.mydwbi.com/posts/preList/30/2969.page GMT http://www.mydwbi.com/posts/preList/30/2978.page http://www.mydwbi.com/posts/preList/30/2978.page GMT keep moving!]]> http://www.mydwbi.com/posts/preList/30/3023.page http://www.mydwbi.com/posts/preList/30/3023.page GMT http://www.mydwbi.com/posts/preList/30/3045.page http://www.mydwbi.com/posts/preList/30/3045.page GMT http://www.mydwbi.com/posts/preList/30/3126.page http://www.mydwbi.com/posts/preList/30/3126.page GMT
]]> http://www.mydwbi.com/posts/preList/30/3140.page http://www.mydwbi.com/posts/preList/30/3140.page GMT http://www.mydwbi.com/posts/preList/30/3272.page http://www.mydwbi.com/posts/preList/30/3272.page GMT http://www.mydwbi.com/posts/preList/30/3308.page http://www.mydwbi.com/posts/preList/30/3308.page GMT http://www.mydwbi.com/posts/preList/30/3318.page http://www.mydwbi.com/posts/preList/30/3318.page GMT 我顶，我顶，我顶顶顶！！]]> http://www.mydwbi.com/posts/preList/30/3330.page http://www.mydwbi.com/posts/preList/30/3330.page GMT
下载好了,,怎么导如进去啊...]]> http://www.mydwbi.com/posts/preList/30/3362.page http://www.mydwbi.com/posts/preList/30/3362.page GMT http://www.mydwbi.com/posts/preList/30/3394.page http://www.mydwbi.com/posts/preList/30/3394.page GMT http://www.mydwbi.com/posts/preList/30/3398.page http://www.mydwbi.com/posts/preList/30/3398.page GMT http://www.mydwbi.com/posts/preList/30/3556.page http://www.mydwbi.com/posts/preList/30/3556.page GMT ]]> http://www.mydwbi.com/posts/preList/30/3630.page http://www.mydwbi.com/posts/preList/30/3630.page GMT http://www.mydwbi.com/posts/preList/30/3675.page http://www.mydwbi.com/posts/preList/30/3675.page GMT http://www.mydwbi.com/posts/preList/30/3693.page http://www.mydwbi.com/posts/preList/30/3693.page GMT http://www.mydwbi.com/posts/preList/30/3695.page http://www.mydwbi.com/posts/preList/30/3695.page GMT http://www.mydwbi.com/posts/preList/30/3719.page http://www.mydwbi.com/posts/preList/30/3719.page GMT http://www.mydwbi.com/posts/preList/30/3792.page http://www.mydwbi.com/posts/preList/30/3792.page GMT http://www.mydwbi.com/posts/preList/30/3814.page http://www.mydwbi.com/posts/preList/30/3814.page GMT ]]> http://www.mydwbi.com/posts/preList/30/3907.page http://www.mydwbi.com/posts/preList/30/3907.page GMT http://www.mydwbi.com/posts/preList/30/4306.page http://www.mydwbi.com/posts/preList/30/4306.page GMT http://www.mydwbi.com/posts/preList/30/4337.page http://www.mydwbi.com/posts/preList/30/4337.page GMT http://www.mydwbi.com/posts/preList/30/4338.page http://www.mydwbi.com/posts/preList/30/4338.page GMT 刚刚接触，还不熟悉……]]> http://www.mydwbi.com/posts/preList/30/4677.page http://www.mydwbi.com/posts/preList/30/4677.page GMT http://www.mydwbi.com/posts/preList/30/10605.page http://www.mydwbi.com/posts/preList/30/10605.page GMT http://www.mydwbi.com/posts/preList/30/82975.page http://www.mydwbi.com/posts/preList/30/82975.page GMT