<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>Informaticans</title>
	<link>http://www.informaticans.com/blog</link>
	<description>All about Informatica</description>
	<lastBuildDate>Thu, 22 Apr 2010 12:51:32 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Router Scenario in Informatica</title>
		<description><![CDATA[Router Scenario:
Lets say  i have more then have record in source table  and i have 3 destination table A,B,C. I have to insert first 1 to 10 record in A then 11 to 20 in B and 21 to 30 in C.
Then again from 31 to 40 in A, 41 to 50 in B and 51 [...]]]></description>
		<link>http://www.informaticans.com/blog/304/router-scenario-in-informatica/</link>
			</item>
	<item>
		<title>Invalid Lookup Sql Override  issue in Informatica?</title>
		<description><![CDATA[Problem:
When using query override, error msg  is &#8221;Invalid lookup override &#8221;  and Below is the Query:
 &#8221;select a.accid, a.trans_date, a.trans_amt from acct_trans a, (select accid, max(trans_date) trans_date from acct_trans group by accid) b where a.accid=b.accid and a.trans_date=b.trans_date&#8221;
Sol:
This error may occurs when using sub-queries in a lookup SQL override and the LookupOverrideParsingSetting custom property is not set.
From the Administration Tab, go [...]]]></description>
		<link>http://www.informaticans.com/blog/301/invalid-lookup-sql-override-issue-in-informatica/</link>
			</item>
	<item>
		<title>Validation rules for Connecting transformations in Informatica?</title>
		<description><![CDATA[Some validation rules:
1-You can only link ports with compatible datatypes.
2-You cannot connect an active transformation and a passive transformation to the same downstream transformation.
3-You cannot connect more than one active transformation to the same downstream transformation or transformation input group.only way to do it using joiner with sorted ports
]]></description>
		<link>http://www.informaticans.com/blog/298/validation-rules-for-connecting-transformations-in-informatica/</link>
			</item>
	<item>
		<title>How to calculate the size of the input data in Informatica</title>
		<description><![CDATA[ 
Use the following formula to determine the size of incoming data:
# input rows ([Sum(column size)] + 16)

]]></description>
		<link>http://www.informaticans.com/blog/296/how-to-calculate-the-size-of-the-input-data-in-informatica/</link>
			</item>
	<item>
		<title>How to remove Duplicates of records using Informatica?</title>
		<description><![CDATA[Lets say you have 2 columns in source table. Do the following in an expression:
A(in)
B(in)
A_Pre(V) = A
B_Pre(V) = B
Comp(V) = IIF( A= A_Pre and B= B_Pre, &#8216;Y&#8217;,'N&#8217;)
Basically you need to store the previous values in a variable and compare with incoming data.
]]></description>
		<link>http://www.informaticans.com/blog/285/how-to-remove-duplicates-of-records-using-informatica/</link>
			</item>
	<item>
		<title>What are the differences between Informatica and Ab-Initio?</title>
		<description><![CDATA[1. Informatica and Ab Initio both support parallelism. But Informatica supports only one type of parallelism but the Ab Initio supports three types of parallesims. In Informatica the developer need to do some partions in server manager by using that you can achieve parallelism concepts. But in Ab Initio the tool it self take care [...]]]></description>
		<link>http://www.informaticans.com/blog/283/what-are-the-differences-between-informatica-and-ab-initio/</link>
			</item>
	<item>
		<title>What is a Node in Informatica?</title>
		<description><![CDATA[ Node :
Node is the logical representation of a machine in a domain. The machine in which the PowerCenter is installed acts as a Domain and also as a primary node. We can add other machines as nodes in the domain and configure the nodes to run application services such as the Integration Service or Repository [...]]]></description>
		<link>http://www.informaticans.com/blog/282/what-is-a-node-in-informatica/</link>
			</item>
	<item>
		<title>What is Domain Configuration in Informatica?</title>
		<description><![CDATA[Domain Configuration:
Domain Configuration Some of the configurations for a domain involves assigning host name, port numbers to the nodes, setting up Resilience Timeout values, providing connection information of metadata Database, SMTP details etc. All the Configuration information for a domain is stored in a set of relational database tables within the repository. Some of the [...]]]></description>
		<link>http://www.informaticans.com/blog/278/what-is-domain-configuration-in-informatica/</link>
			</item>
	<item>
		<title>What is a Domain in Informatica?</title>
		<description><![CDATA[PowerCenter Domain
A domain is the primary unit for management and administration of services in PowerCenter. Node, Service Manager and Application Services are components of a domain.
]]></description>
		<link>http://www.informaticans.com/blog/271/what-is-a-domain-in-informatica/</link>
			</item>
	<item>
		<title>TM_6270 Error: Variable parameter expansion error in Informatica</title>
		<description><![CDATA[There should be some typo in the Parameter file. Please check the following:
1)The Folder name should be exactly the same where this workflow/Session is
lying.
2)Check the authenticity of the Value that you are passing for the Parameter
in the Parameter file.
3)The most important, please check the trailing spaces of the Value,
Foldername,Workflow/Session name. Most of the times, because [...]]]></description>
		<link>http://www.informaticans.com/blog/268/tm_6270-error-variable-parameter-expansion-error-in-informatica/</link>
			</item>
</channel>
</rss>
