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

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

 7 11559

how can we perform incremental aggregation?explain with example?

 9 20877

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 11897

If we are using an aggregator but forget to mention the group by port .what will be the output??

 11 30669

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

 3 9155

What is the difference between bitmap and btree index?

 2 8938

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

 5 18321

How can i set break points in debugging mode ? can explain steps please?

 1 13527

How can we get multiple output values using an unconnected lookup transformation?

 2 15441

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

 2 6608

what is threshold error in informatica?

 1 19559

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

 6 13758

List the transformation in informatica.

 1 11551

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

 2 14411

what is the use of Java Transformation in Informatica 8.x?

 2 12456

Post New TCS Informatica Interview Questions


TCS Informatica Interview Questions


Un-Answered Questions

How to fix a munged log in sybase?

478

What is faster array or arraylist?

461

What is mamimum rate of CST applicable on Plastic Doors in NOIDA?

1608

Mention what are the styling form that ngmodel adds to css classes?

517

What do you mean by distribution transformers?

662




Data Engineer Given a list of followers in the format:123, 345234, 678345, 123…Where column one is the ID of the follower and column two is the ID of the followee. Find all mutual following pairs (the pair 123, 345 in the example above). How would you use Map/Reduce to solve the problem when the list does not fit in memory?

486

What is promises in node js?

250

What are the most useful plugins in jenkins?

1

Can you create an object of an abstract class?

547

What are the different types of automatic bidding strategies?

220

what is the use of schedule prompting in client schedule backups?

491

What are the features of react?

204

What is data modelling techniques?

425

How can I create a div work like an input?

503

What is sla's, how are they different from agents?

189