To perform the following tasks. Get a related value. For example, if your source table includes employee ID, but you want to include the employee name in your target table to make your summary data easier to read. Perform a calculation. Many normalized tables include values used in a calculation, such as gross sales per invoice or sales tax, but not the calculated value (such as net sales). Update...

vivek1708

 Profile Answers by vivek1708 Questions by vivek1708

• May 8th, 2008

Hi The ans to ur question is YesThere are 2 types of lookups: Dynamic and Normal (which you have termed as Static).To configure, just double click on the lookup transformation and go to properties tab...

binoop

• Mar 22nd, 2007

For maintaining the slowly changing diamensions

Answer Question  Select Best Answer

Raja

• Feb 27th, 2007

Regarding transformations:In 7.1We use look up on flat filesthere is union transformation

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 6th, 2007

Diffrences of informatica 6.1&7.1

Answer Question  Select Best Answer

superhero

 Profile Answers by superhero Questions by superhero

• Dec 5th, 2008

Local---------->versioned,non-versionedglobal--------->versioned,non-versioned

adilshariff

 Profile Answers by adilshariff Questions by adilshariff

• Jul 1st, 2008

There are two types1.GDR and LDR2.Versioned and NonVersionedWe can use them in combinations, meaningGDR [Versioned/Non Versioned[Default]]LDR [Versioned/Non Versioned[Default]

Answer Question  Select Best Answer

Baloo_nanduri

 Profile Answers by Baloo_nanduri Questions by Baloo_nanduri

• Jul 25th, 2010

Yes, its possible using Update override option available for Targets in designer

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Sep 3rd, 2009

We can update the target table, by using the update override in target definition. it will update based on non key columns.

Answer Question  Select Best Answer

na123

 Profile Answers by na123 Questions by na123

• Aug 22nd, 2006

hey kiran,   u can solve this problem by using mapping variable where u need to mention the start value and end value.when u end ur session then that variable will take the next value as the...

abdulla

 Profile Answers by abdulla Questions by abdulla

• Aug 19th, 2006

hi,  u can use mapping variable concept for this.

Answer Question  Select Best Answer

rajvinformatica

 Profile Answers by rajvinformatica Questions by rajvinformatica

• Mar 28th, 2010

I have written as Stored Procedure to get all the Tables from a two Server Server1 and Server2 (parameterized Values) and load them in to two different tables internally through the S.PThis ...

sarita.harsh

 Profile Answers by sarita.harsh Questions by sarita.harsh

• Mar 5th, 2009

Create a dummy mapping with dummy as source and target column. Then create a session corresponding to this mapping. In the session go to tab Mapping.Then select the source in task type. In connecti...

Answer Question  Select Best Answer

satya

• Mar 17th, 2016

Connected Lookup is nothing but it connects to source and target. It can receive multiple inputs returns multiple output.

Unconnected Lookup connects either source or target. It takes multiple inputs but returns single output.

Thank You
Satya

Ketaki Kulkarni

 Profile Answers by Ketaki Kulkarni Questions by Ketaki Kulkarni

• Dec 7th, 2009

Apart from the answers above here is the difference between Static and Dynamic Cache.Static cache is created when the Lookup transformation is encountered for the first time. If this cache is set to b...

Answer Question  Select Best Answer

pallavi

• Nov 6th, 2006

Hi,Lookup is used to look into some other table to get the details for the related information of the current table. These tables have a common column and we get the related information if the condition satisfies.Pallavi

Shravan Gopisetty

• Sep 24th, 2006

We use Look up transfermations to implement the SCD to Implement the CDC(Change Data Capture).The following tasks can be implemented with look up transfermation.1.Get a Related value.2.SCD3.For calcul...

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 14th, 2010

I think this can be done by incremental aggregation at source side and target side

sanjeev

• Aug 6th, 2007

I have one more idea. I think it is right.In source qualifier we have a pre SQL and post SQL. using the pre SQL we can insert 4 and 5 records there.Sanjeev

Answer Question  Select Best Answer

Anindya1281

 Profile Answers by Anindya1281 Questions by Anindya1281

• May 11th, 2010

This can be done using SQL query in case of relational sourcesvariables in an expression in case of reltn and flat file srcsIn case of Infa 8.x we have an inbuilt function called MD5 which can be used...

sravan

• Nov 4th, 2006

We can aso use sorter transfermation.seect distinct one check box.

Answer Question  Select Best Answer

sai kiran

• Oct 20th, 2007

If possible using Lookup will give better performance over joiner.Using lookup we can perform?outer joins, equi, and non equi joins.Using joiner we can perform only equi joins.In lookup we can also write SQL ovverrides.

guy.sridhar

 Profile Answers by guy.sridhar Questions by guy.sridhar

• Oct 15th, 2007

The exact difference is, by using joiner we can get both matching and unmatching records from the table .By using look up we can find out whether the records exists or not.and other thing we can ...

Answer Question  Select Best Answer

Thananjayan

 Profile Answers by Thananjayan Questions by Thananjayan

• Dec 6th, 2007

We have Session,Command and Email tasksCheers,Thana

Siddhant Mirji

• Jul 11th, 2007

SessionCommandDecisionEvent WaitEvent raiseEmailTimerAssignmentControlWorklet

Answer Question  Select Best Answer

ramakrishna

• Sep 22nd, 2007

A measurable data on which simple addition can be performed is called fully additive such measurable data's no need to combine two or more dimensions for it's meaningEx: Product wise total salesBr...

murali

• Nov 27th, 2006

Average monthly balance of your bank account is a semi-additive fact.

Answer Question  Select Best Answer

anju

• Mar 2nd, 2007

In ODS there is no historic data. ODS holds data temporarily. ie for reporting purpose.

MANOJ KUMARPANIGRAHI

• Feb 21st, 2007

ODS(opertional data store) It is part of the data warehouse architecture. It is the first stop for the data on its way to the warehouse. It is here where I can collect and integrate the data. I can en...

Answer Question  Select Best Answer

ravikumar.amudala

 Profile Answers by ravikumar.amudala Questions by ravikumar.amudala

• Aug 26th, 2009

Now we dont have that problem, now sequence generator trans is have some around 18 digit number, so the problem is solved.if it extends more than that, go for stored procedure.RegardsRavi

ask_kaushik

 Profile Answers by ask_kaushik Questions by ask_kaushik

• Dec 6th, 2007

use a Stored Procedure transformation where the stored procedure generates keys after checking the max in the target.

Answer Question  Select Best Answer

What is the difference between index cache and data cache

santosh

• Dec 26th, 2011

Index cache : Integration service stores all conditional values in to the index cache and all output values into the data cache.

Please correct me anything wrong

skaur29

 Profile Answers by skaur29 Questions by skaur29

• Nov 17th, 2011

If we talk with respect to Aggregate Transformation , then Index Cache stores the Group Values and data Cache stores the Actual Data which is Row data.

Answer Question  Select Best Answer

What are the caches available in Joiner transformation?What is stored in Joiner cache(data cache) and Index cache?

Rashmirekha

 Profile Answers by Rashmirekha Questions by Rashmirekha

• Sep 2nd, 2009

For Unsorted Input joiner transformation, i) Data cache stores all master rows in the join condition with unque index keys ii) Index cache stores all master rows.For Sorted Input with Different ...

raam.pt

 Profile Answers by raam.pt Questions by raam.pt

• Aug 18th, 2009

Caches in JTR are 2.
1) Data Cache
2) Index Cache
1) Data Cache: It stores master source rows OS source table as configured in join condition.
2) Index Cache: It stores index values for master.

Answer Question  Select Best Answer

The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and code page validation in the Informatica Client and Server.a) Unicode - IS allows 2 bytes for each character and uses additional byte for each non-ascii character (such as Japanese characters)b) ASCII - IS...

Read Best Answer

Editorial / Best Answer

Answered by: purushotham

• Aug 9th, 2005

---

the two types of modes are: 
1) Normal Mode in which for every record a separate DML stmt will be prepared and executed 
 
Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.

amolrenose

 Profile Answers by amolrenose Questions by amolrenose

• Sep 18th, 2011

Data Movement Modes

1. ASCII mode :- Single byte of data is processed.
2. UNICODE mode :- Two bytes of data is processed.

Data Loading Modes

1. Normal Mode :- Commit is executed after 10000 records (default).
2. Bulk Mode :- Commit is executed after all records have been loaded.

sivakp

 Profile Answers by sivakp Questions by sivakp

• Mar 13th, 2011

1. ASCII mode2. UNICODE mode

Improve Answer

NO. We can use mapping parameters or variables in any transformation of the same maping or mapplet in which U have created maping parameters or variables.

CeeJay

• May 30th, 2013

No. It cannot be used in different mappings as when it is saved in the repository, it is saved for a particular mapping. And at global level we have mapping parameters only and not variables which cannot be changed.

Tapas

• Oct 6th, 2007

The scope of a mapping variable is the mapping in which it is defined. A variable Var1 defined in mapping Map1 can only be used in Map1. You cannot use it in another mapping say Map2.

Answer Question  Select Best Answer

pr

• Mar 10th, 2016

Joiner : > It support equiv Join only. > It may be we can perform outer join only. > Joiner is used to source only. > It may be only "=" operator used. > In joiner may be not present in lookup ov...

Nishikant Shekhar

 Profile Answers by Nishikant Shekhar Questions by Nishikant Shekhar

• Jul 22nd, 2009

Lookup transformation is a Passive transformation where as Joiner is Active Transformation.Lookup you can have both connected as well as unconected where as Joiner is always connected.Joiner is used t...

Answer Question  Select Best Answer