John

• May 29th, 2013

Sort all the records by country name. in expr transformation include the below variables v_countout=IIF((v_currcountry=vprevcountry),v_count,vcount+1) basically incrementing the count if the country ...

Mahesh Manam

• May 6th, 2013

Using Router transformation we will achieve this.

S -> SQ -> RTR -> T

In router,create 10 groups for 10 countries

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 10th, 2008

SELECT *FROM (select * from source_table ORDER BY rownum DESC) SourceWHERE rownum <= 501

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 12th, 2007

u can load 500 records, then we can use Transaction control transformation, give the condition for 500 records out of 1000.

Answer Question  Select Best Answer

The goal of performance tuning is optimize session performance so sessions run during the available load window for the Informatica Server.Increase the session performance by following. The performance of the Informatica Server is related to network connections. Data generally moves across a network at less than 1 MB per second, whereas a local disk moves data five to twenty times faster. Thus network...

srinivas

• Oct 4th, 2011

Your approach to that question and answer is perfect and correct

ankitmohansharma

 Profile Answers by ankitmohansharma Questions by ankitmohansharma

• Jan 13th, 2008

Hey, Thank You so much for the information. That was one of the best answers I have read on this website. Descriptive yet to the point and highly useful in real world. I appreciate your effort.

Answer Question  Select Best Answer

Persistent cache: U can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache. Recache from database: If the persistent cache is not synchronized with he lookup table,U can configure the lookup transformation to rebuild the lookup cache. Static cache: U can configure a static or readonly cache for only lookup table.By...

adhoc

• Sep 13th, 2011

There are 2 important caches. 1. Static : By default integration service chooses statyic cache.It is read only cache . when you first query the lookup table, it caches the table. whenever a row com...

Mattock

• Sep 7th, 2011

Caches are of following types:
1. Static Cache
2. Dynamic Cache
3. Persistent Cache
4. Non-persistent Cache
5. Shared Cache
6. Un-shared Cache

More types to follow...:-)

Answer Question  Select Best Answer