<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cq75976的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cq75976</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cq75976]]></copyright><item><title><![CDATA[lookup trans and expression variable use]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198814</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198814</guid><author>cq75976</author><pubDate>Wed, 19 Jun 2013 17:37:20 +0800</pubDate><description><![CDATA[Ø Lookup override query
1. in this query, must use “as” to define the column, otherwise, Informatica will ...]]></description><category></category></item><item><title><![CDATA[保存文件名为年月日]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198826</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198826</guid><author>cq75976</author><pubDate>Thu, 21 Mar 2013 13:46:31 +0800</pubDate><description><![CDATA[touch $ARCHIVE_PATH/aa_`date +%m%d%y`.dat
                                                            
           ...]]></description><category></category></item><item><title><![CDATA[flat file content error]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198813</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198813</guid><author>cq75976</author><pubDate>Mon, 18 Mar 2013 16:11:11 +0800</pubDate><description><![CDATA[error:row[2555] 824th-null in the text fiel,which is donot allowed in the txt fie

是说file里的第2555 行第824个字符有问题,su...]]></description><category></category></item><item><title><![CDATA[SQ or Lookup override query issue]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198822</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198822</guid><author>cq75976</author><pubDate>Thu, 10 Jan 2013 16:46:52 +0800</pubDate><description><![CDATA[when using SQL override,it get error "invalid query" and ask to contact xxx admin
but can get successful in PL/SQ...]]></description><category></category></item><item><title><![CDATA[grant and 常用数据字典]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198812</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198812</guid><author>cq75976</author><pubDate>Fri, 23 Nov 2012 20:14:06 +0800</pubDate><description><![CDATA[除了grant select,update... on to xxx 。可以直接
Grant all on scott.emp to test

常用数据字典
user_sys_privs
all_tab_colu...]]></description><category></category></item><item><title><![CDATA[merge]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198811</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198811</guid><author>cq75976</author><pubDate>Thu, 15 Nov 2012 17:14:40 +0800</pubDate><description><![CDATA[转载
该命令使用一条语句从一个或者多个数据源中完成对表的更新和插入数据. ORACLE 9i 中，使用此命令必须同时指定UPDATE 和INSERT 关键词,ORACLE 10g 做了如下改动。
1，insert 和up...]]></description><category></category></item><item><title><![CDATA[rownum and rowid]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198808</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198808</guid><author>cq75976</author><pubDate>Tue, 13 Nov 2012 22:15:48 +0800</pubDate><description><![CDATA[rownum是个虚拟的字段，它是在记录输出的时候逐步产生的。
和rownum相似，oracle还提供了另外一个伪数列：rowid。不过rowid和rownum不同，一般说来每一行数据对应的rowid是固定而且唯一的，在这一行数...]]></description><category></category></item><item><title><![CDATA[row_number,rank,dense_rank]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198807</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198807</guid><author>cq75976</author><pubDate>Tue, 13 Nov 2012 22:03:59 +0800</pubDate><description><![CDATA[转载--
一、使用rownum为记录排名：在前面一篇《Oracle开发专题之：分析函数》，我们认识了分析函数的基本应用，现在我们再来考虑下面几个问题：①对所有客户按订单总额进行排名②按区域和客户订单总额进行排名③找出订单总额排...]]></description><category></category></item><item><title><![CDATA[rownum 与order by]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198820</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198820</guid><author>cq75976</author><pubDate>Tue, 13 Nov 2012 21:56:55 +0800</pubDate><description><![CDATA[oracle的rownum字段是个比较奇怪的字段。拿一张有26条记录的Test表来举例。 select * from Test where rownum &gt;=1
第一条sql查出了26条记录.rownum是个虚...]]></description><category></category></item><item><title><![CDATA[clob use]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198873</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198873</guid><author>cq75976</author><pubDate>Fri, 01 Jun 2012 21:08:56 +0800</pubDate><description><![CDATA[clob datatype take so much space ,in the source and target use varchar2(xxx) to replace clob to truncate length.
...]]></description><category></category></item><item><title><![CDATA[get error in informatica logs]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198818</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198818</guid><author>cq75976</author><pubDate>Thu, 17 May 2012 17:47:28 +0800</pubDate><description><![CDATA[#!/bin/kshsession_log_path=/data/informatica/Renewables/WINMF01/SessLogslog_file_name=$1file_saved=$2folder_nam...]]></description><category></category></item><item><title><![CDATA[compress ,tar,find ,wc,$?]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198900</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198900</guid><author>cq75976</author><pubDate>Thu, 10 May 2012 22:30:52 +0800</pubDate><description><![CDATA[if directly upload the script. into unix sever and run it,it occurs some strange issues like '`/data/informatica/H...]]></description><category></category></item><item><title><![CDATA[if 判断语句]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198756</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198756</guid><author>cq75976</author><pubDate>Thu, 10 May 2012 22:21:49 +0800</pubDate><description><![CDATA[#! /usr/bin/bashread num;if [ $num -eq "100" ];thenecho "num=100"echo "xxx"elseecho "num!=100"fi
=----'-eq', &g...]]></description><category></category></item><item><title><![CDATA[9.1 parameter file]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198768</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198768</guid><author>cq75976</author><pubDate>Tue, 08 May 2012 16:29:41 +0800</pubDate><description><![CDATA[item1---使用parameter file 设置path,such as :session log ,source path and so on 
[Global]$PMMergeSessParamFile=TRUE$P...]]></description><category></category></item><item><title><![CDATA[flat file date datatype]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198750</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198750</guid><author>cq75976</author><pubDate>Tue, 08 May 2012 16:21:28 +0800</pubDate><description><![CDATA[当SOURCE是 flat file，且有date 数据,而TARGET oracle table 是date datype,要在transformation中用to_date(xxxx,'xx--xx--xxxx')，日期f...]]></description><category></category></item><item><title><![CDATA[scripts]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198767</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198767</guid><author>cq75976</author><pubDate>Wed, 15 Feb 2012 20:35:07 +0800</pubDate><description><![CDATA[upload the scripts into informatica server must be in ASCII mode 
                                                ...]]></description><category></category></item><item><title><![CDATA[fetch parameter value]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198745</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198745</guid><author>cq75976</author><pubDate>Tue, 31 Jan 2012 19:53:05 +0800</pubDate><description><![CDATA[当一个session用于几个不同的workflow时，在SQ中用到parameter and value take from file ,这里不同用固定的格式， '[WINMF01.WF:' || var_WORKFLOW ...]]></description><category></category></item><item><title><![CDATA[sql override]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198751</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198751</guid><author>cq75976</author><pubDate>Thu, 12 Jan 2012 16:44:40 +0800</pubDate><description><![CDATA[look up transformation or other in sql override -----不需要select from table与transformation可以不一样，而transformation里的por...]]></description><category></category></item><item><title><![CDATA[last load date]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198741</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198741</guid><author>cq75976</author><pubDate>Thu, 12 Jan 2012 16:30:24 +0800</pubDate><description><![CDATA[setvariable(xxx,sysdate)---这个只有在有数据通过时，才能生效，否则日期不变
                                                            
  ...]]></description><category></category></item><item><title><![CDATA[PK and sequence]]></title><link>https://blog.youkuaiyun.com/cq75976/article/details/100198764</link><guid>https://blog.youkuaiyun.com/cq75976/article/details/100198764</guid><author>cq75976</author><pubDate>Fri, 06 Jan 2012 20:50:18 +0800</pubDate><description><![CDATA[主键那个列可以每次用sequence来实现赋值，但也可以不用所以max(PK)与sequence.CURRVAL不一定相等是吧定sequence是个独立的存在，与表的列没有必然的联系
                    ...]]></description><category></category></item></channel></rss>