Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

TCS Informatica Interview Questions
Questions Answers Views Company eMail

Can we change Dynamic to Static or Persistent cache? If so what happens?


What is Java Transformation? what are the uses of it?


Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 9201

Can we update a target table (without primarykey) by using update strategy transformation?

4 15129

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 4921

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 3118

Which one is better performance wise connected/un-connected lkp?why?

2 8040

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?


why we are using level option in normalizer transformation


following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 5035

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 6440

how the informatica server sorts the strings values in rank transformations?

3 12294

can you use flat file for repository?why?

2 4902

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 6110

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 6798

Post New TCS Informatica Interview Questions

TCS Informatica Interview Questions

Un-Answered Questions

A. What two basic questions must be answered by an inventory control decision rule? B “If line employees are required to work on quality improvement activities, their productivity will suffer.” Discuss.


What are the differences between heap and stack memory?


i want for interview question & answer plz it need immediate send t my mail


What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?


what is an unbalance in acircuit? in a three phase 3wire circuit how an unbalance will come? in a three phase four wire system how an un balance is coming?


What is the purpose of using om?


What are orabulk and bcp stages?


What is the use of ember.trackedarray?


Is it true that all c# types derive from a common base class?


Tell me what are the different types of errors in php?


What is GainSpan’s GS2000 Protocol for the Internet of Things (IoT)?


What is the difference between "revocable beneficiary" and "irrevocable beneficiary"? : insurance sales


What is a Assembly?


What do you mean by data center in Cassandra?


What do you mean by queries?