Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 5943

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 5851

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 18233

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

1 1947

Why we require dwh in particular projects?

1 3814





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 14814

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 5332

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 28163

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

1 3258

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 4994

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

3 10641

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

2 4951

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 5041

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 7943

Post New Amdocs Informatica Interview Questions




Amdocs Informatica Interview Questions


Un-Answered Questions

i want last 5 yrs Q papers of rrb(any) send me at puneetchauhan_8782@yahoo.co.in

1348


What is spring security?

30


what is diff between idocs,bdc,rfc and bapi. give real time answer

15602


How can I set the path or any other environment variable for a task or entire playbook?

1


What are the 2 sqlcodes that are returned?

279






What is ctrl h?

147


Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

59


What is difference between debit card and credit card?

335


How do I fix werfault exe in windows 10?

165


Which function in r language is used to find out whether the means of 2 groups are equal to each other or not?

50


What is a block element?

229


How do we Test the C++ and Unix Application Using Automated Tool.

1551


What are the different applications of rpa?

1


How do you insert a table of contents in word on a mac?

142


Is windows 7 becoming obsolete?

194