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

Deloitte Informatica Interview Questions
Questions Answers Views Company eMail

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

 10 32699

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

 7 23223

What is checksum termnology in informatica? Where do you use it ?

 3 26671

What is the term PIPELINE in informatica ?

 7 31660

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

 15 29976

How to handle changing source file counts in a mapping?

 3 17495

What are set operators in Oracle

 3 15782

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

 9 16562

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

 21 33927

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 14398

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

 3 24291

What is the difference between IN and Exists in Oracle?

 3 14476

Can we have a Mapping without a Source Qualifier?

 14 45589

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

 2 11902

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

 7 25076

Post New Deloitte Informatica Interview Questions


Deloitte Informatica Interview Questions


Un-Answered Questions

What is availability check?

694

What is authorization in asp.net?

567

What is formal testing?

669

How will you backup dns server?

109

Differentiate ‘variant bom’ from ‘multiple bom’?

652




How do you document ABAP programs? Do you use program documentation menu option?

638

Which keyword is used to accept variable number of parameters?

680

Name the parasite, which causes malaria?

323

A certain radioactive element A, has a half life = t seconds. In (t/2) seconds the fraction of the initial quantity of the element so far decayed is nearly how much?

1722

What checkbox method allows you to tell if a checkbox is checked?

529

Which type of object requires this object?

1494

What are check tables?

486

How to display the schema of the model?

7

What is latest version yii 2 framework?

3

What is cluster index?

5