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 4735

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 4898

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 15716

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

1 1226

Why we require dwh in particular projects?

1 3132





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 12719

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 4435

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 23060

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

1 2439

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 4144

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

3 9091

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

2 4154

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 4194

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 6354

Post New Amdocs Informatica Interview Questions



Un-Answered Questions

Name the class that is used to bind the server object with RMI Registry?

1039


IF I USED VVVF DRIVE IN FAN APPLICATION MOTOR IN 6.6 KV ( 700 KW) MOTOR & DURING NORMAL RUN OPERATION TIME IF RPM SUDDENLY REDUCE IN MOTOR BY DRIVE(E. MOTOR RPM REDUCE SUDENLY 687 TO 550 RPM) WAHT WILL BE HAPPEND IN DRIVE

1241


How will you trigger the idoc?

1012


What truth-in-advertising rules apply to advertisers? Under the Federal Trade Commission Act?

1462


HOW TO FILL UP WEST BENGAL VAT FORM 14. NOT TECHNICALLY I AM AWARE ABOUT THEIR MANUAL. BUT I WANT TO KNOW POINT BY POINT.

8378






What is meant my data qutoe error In ms office

1594


1) what template u use to get the data for preparing business blueprint. 2) what challenges u face while preparing business blueprint..pls answer my questions

859


I have a 380 KVA DG set. How can i find out 1. My Fuel Consumption per hr ? 2. Electricity produced in 1 Hr. ? 3. If load varies then how does it affect fuel consumption & electricity produced ? Please HELP !!! Really need an answer.

1048


compare between starting charactristics of synchronous motor with those of 3Q Squirrel cage induction motor

477


what are the structures on the gills of mushrooms?

856


If 100 KAV USP dedicated earth got disconnect / Cut. What will happen at load.

586


best manufacturer for busbar for outdoor switchyard having double bus bar scheme, can any one share technical specification of busbar. 132kv voltage ?

567


How does a cherry seed germinate?

881


How do we calculate the resistance per metre of single core aluminium stranded cable 19*3.25mm sheathed in pvc,at 15 deg C temperature?

1121


What are the effects of corona in switch yard.

914






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)