- 博客(6)
- 资源 (36)
- 收藏
- 关注
转载 DB2 Merge into
DB2 MERGE INTO语句的使用 DB2中的Merge语句可以将一个表中的数据合并到另一个表中,在合并的同时可以根据条件进行插入、删除、更新等操作,功能非常强大。 语法如下:www.2cto.com MERGE INTO table_name alias1USING (table|view|sub_query) alias2ON (join condit
2016-04-27 14:01:14 1110
转载 DB2 rank和rownumber 区别
rank和rownumber都是自动生成序号,后面都可以跟partition by分组和order by 排序。不同之处在于,rownumber在order by后面的字段,排序字段数值相等时,rownumber字段依次递增。 rank在order by后面的字段,排序字段数值相等时,rownumber都相同,直接跳到下一个不同的序号。select rank
2016-04-12 21:34:14 6813
转载 Finding all mappings that use a table as source, target and lookups
If you are using version 7.x, this query will get you list of all the mappings that use the table as source, target and lookup. You need to change the 'FOLDER_NAME' filter value, or remove it.
2016-04-08 16:08:21 369
转载 find a list of mapping affect special talbe in informatica
Informatica metadata repository stores and maintains information about all the objects in Informatica.So , you have to write an external query to find this : SELECT SUBJECT_AREA , MAPPING_NAM
2016-04-08 15:54:30 370
转载 using multiple parameter files in informatica
You must follow below steps, or you will be failed.Workflow and Session Level Parameter FileWhen we define a workflow parameter file and a session parameter file for a session within the workflow,
2016-04-08 14:36:35 653
转载 parameter in Inforamtica
Stop Hardcoding- Follow Parameterization Technique Details Written by Saurav Mitra Category: Informatica Last Updated: 16 September 2014Hits: 24148 This a
2016-04-08 14:33:00 1141
Oracle-pexam_1Z0-060.docx
2021-09-12
redhat6.5 oracle ASM驱动
2016-04-27
SQL server compact 3.5
2012-12-04
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人