Amdocs Informatica Interview Questions Answers, Amdocs Placement Papers, Amdocs Technical, HR Interview Questions, Amdocs Aptitude Test Questions, Amdocs Campus Placements Exam Questions

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 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 7691

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 7532

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 21429

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

1 3386

Why we require dwh in particular projects?

1 5300

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 17862

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 7065

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 33702

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

1 4695

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 6893

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

3 13811

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

2 6930

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 6954

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 11377

Post New Amdocs Informatica Interview Questions

Amdocs Informatica Interview Questions

Amdocs Informatica Interview Questions (14)

Un-Answered Questions

What do you mean by unix operating system?

953

Can visual studio compile c?

768

All of the following are true regarding Pareto diagrams and Pareto theory except: A. Pareto diagrams are histograms. B. Pareto diagrams rank order factors. C. A small number of causes create the majority of problems. D. Pareto diagrams use two variables.

1110

Is there a guarantee of uniqueness for entity beans?

1059

How do you shut down a word document that is frozen?

541

Brief working principle of stabilizer,application & safety precautions

5736

What is a surrogate key?

1153

what are the other factors of the database on which the loading performance depend?

1957

When we use Abstract Class and when we use Interface?where we will implement in real time?

2242

What is the reason for using a GE G101 MCB in place of an EP102 MCB if both are capable of AC circuit protection?

2713

What is the reason for emitting the white exhaust smoke during start of the vehicle? How will you prevent this?

1120

What are Features of Recursion?

What are common risks at Allstate? And how to face?

1305

Please state briefly the reasons why you think you are an outstanding candidate for this job

12855

What method is invoked to cause an object to begin executing as a separate thread?

1094