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

  • Amdocs aptitute test questions (6)
  • Amdocs interview questions (85)
  • Amdocs placement papers (2)
  • Amdocs technical test questions (9)

Amdocs Informatica Interview Questions
Questions Answers Views Company eMail

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 4581

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 4716

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 15184

What is the role of informatica in project ?Like i showed financial projects?

1 1107

Why we require dwh in particular projects?

1 2988

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 12328

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 4235

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 22280

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 2304

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 4012

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 8858

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 4045

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 4068

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 6136

Post New Amdocs Informatica Interview Questions

Un-Answered Questions

Highlight the facilitating and/ or inhibiting factors


i am preparing for aai atc ? plz can u send me som emodel qus?


did the division manager sets the goal in the best way?


How capacitor improves pf


Explain about the Optimizer values passed in Oracle?


what is recovery factor


hi friends... this is priya.i had 1 year of experiance in manual testing from jan-dec 2011 in a reputed level 5 MNC and my CTC was 3.25LPA . recently i cleared 2 rounds of technical interviews and in few more days i will have hr interview in a CMMI level3 company... in hr interview they may ask about expected ctc.what i should answer for this question? i had more than a year gap, so what package i can expect? same CTC or some % of hike or as per the company norms?


Consider a fixed subnet partition of a class B network number that will accommodate at least 76 networks. How many hosts can be on each network? Also mention how you calculated that.


sir, i am serving in indian air force. i have to appear in an personal interview for manager in banks shortly. please provide the ideal answere of the question like introduce your self. and why you want to leave air force and join banking sector. thankyou


please send me model question papers for DVC Examination diploma mechanical


What is meant by retiring Bill


which the best institute in india to get trained on telecom protocol testing? am a e.c.e fresher


what deference between panel earth and systemearth


whenever run depreciation, automatically updation income tax depreciation with the same percentage?What is the problem?can u give me solution?


What are some other hard problems ?


Amdocs Informatica Interview Questions
  • C (4)
  • Networking AllOther (1)
  • Oracle General (1)
  • SQL Server (1)
  • MySQL (1)
  • SQL PLSQL (2)
  • Linux Commands (1)
  • Unix AllOther (2)
  • Load Runner (2)
  • QTP (2)
  • Manual Testing (21)
  • Mobile Testing (1)
  • Testing AllOther (4)
  • COBOL (6)
  • CICS (2)
  • DB2 (4)
  • Assembler (3)
  • Core Java (12)
  • Teradata (1)
  • Informatica (14)
  • Data Stage (3)
  • Telecom Protocols (1)
  • Oracle Apps Technical (2)
  • Electrical Engineering (1)
  • Engineering AllOther (1)
  • Business Administration (1)
  • NDA (1)
  • Everything Else AllOther (1)
  • General Aptitude (4)
  • Placement Papers (2)