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 4304

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 4489

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 14461

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

1 953

Why we require dwh in particular projects?

1 2836

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 11789

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 3967

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 20957

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

1 2114

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 3838

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

3 8503

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

2 3881

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 3902

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 5809

Post New Amdocs Informatica Interview Questions

Un-Answered Questions

what are PI and human lymphocyte cultures?


how do use session mapping parameters ?(in which transformation)


Hi SD Gurus, Have you involved in any Development work for your client? What is the development task that you done for your client / assigned by your client? I want only Business Scenarios, no theory and how did you meet the client requirement which is not met by SAP Standard configuration? I want detailed Procedure, Analysis, Simple coding if any (Please Do not give complex coding steps) Detailed explanation, steps, along with resolution and give more emphasis on how did you arrived at the solution / resolution and logic behind it? I have been asked this question in an recent interview? It’s Urgent!!!!!! Please provide 2-4 real time data examples from your SAP SD Implementation Project? This is most frequently asked question in almost in all interviews. So, I request you to provide solutions to above question as early as possible? Your timely help would be greatly appreciated? Thanks in advance Regards


Pls can anyone give me the entire code for the Keyword driven framework with respect to he Flight Reservation Window in detail with explanation. Pls explain in detail stepwise. Thanks a lot. Pls very urgent?.


what will be the angular speed of a model of turbine whose dia is half of the real one and operating in 1/4 th of the head of the real turbine rotating in Nrpm.


reversing of each word in the string


how to hide prompts


1.Write a CRITICAL test cases for calculator ? 2.What is the difference b/w FRS and SRS documents ? 3.What is Component ? 4.What is object ? 5.what is the difference b/w static and dynamic descriptive programming ?


HI, I am applying for a position of a team manager and the company I have an interview scheduled for is looking for a good knowledge in queue management software's like Blue Pumpkin and Avaya CMS. Could some one help me with a few samples of what kind of questions I can expect? Thanks in advance


integration with fi to pp steps


What are the key issues that should be addressed in the design, conduct and evaluation of training programs?


charge at rest result in e.f and charge in motion result in m.f then how can an accelerated charge give rise to emf wave? then there should be no e.f due to acc charge as it rise from charge at rest?




what do you mean by correlation ? explain different types of correlation


hi this is hema, r there any books in particular for the preparation of the APPSC-A.E.E(electrical), if so please mail me the names ... thank u .


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)