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?

 1706

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

 2405

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 12799

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

 4 21905

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

 2 6382

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 4233

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

 2 12566

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?

 1743

why we are using level option in normalizer transformation

 1 6208

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 6922

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

1 7894

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

 3 15252

can you use flat file for repository?why?

 2 6288

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 8225

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

 2 8353

Post New TCS Informatica Interview Questions


TCS Informatica Interview Questions


Un-Answered Questions

What is your previous work experience?

171

why dimmerstate always connected in star connection? what will happen if it connected in delta?

1564

Can we change the value of static variable in c?

550

Explain what is post-processor?

327

Is it cost effective to implement a private cloud rather than a public cloud and why?

411




How can we use multiple transactions by using bdc_insert? : abap bdc

630

What are the annotation used in spring?

153

What is arraylist c#?

453

How do I run a script on mac?

563

How do I enable activex?

391

Can any one suggest how to write the bug reports effectively by optimizing what we want to describe?

1530

What is method reference in java?

546

Which method do you use to enforce garbage collection in .net?

508

What is Partioner in hadoop? Where does it run

621

What is the difference between substr & instr functions?

589