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 7782The 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 7650If 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 21590Where 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 18018If 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 7161What 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 33900Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
1 4801My 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 7041I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
3 13976while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
2 7097Hi 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 7124My 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 11620Post New Amdocs Informatica Interview Questions
sir, please send HPCL INFORMATION SYSTEMS OFFICER SYLLABUS WITH PREVIOUS QUESTION PAPERS
What is the Working principle of Dozing valve?
a web application needs to be created to accept the product name and quantity of a toy from a customer. After the customer has entered the product name the application needs to display the discounted price of the product to the customer (company is offering 35% discount on all products). The application should allow the customer to select the product name from a list box. and also while i'm data binding to a label with custom data binding with some declarations : "The Discounted Price is "+((System.Convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)) - ((System.convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)*0.35)). Where i need to give this declaration in asp.net 2.0.
i am a student i need the technical questions ased in wipro
name 5 indian business man name who have great business impact all over india .plz tell me some importent point.
How we can read a file in node js?
How you can configure an orbix domain to contain corbaloc references instead of iors for the orbix services?
hi... if anybody wrote Airport Authority of India(ATC) examination.... pls kindly post the Questions wat they asked... specially in English & Reasonings.... it will useful to all others who are going to write AAI (Electronics) exam....
sampile paper for dme in rrb exam
How to record the desktop application in Loadrunner 12.53 version 64 bit window.
Explain the difference between data bias and algorithmic bias.
Tell me why haven't you worked recently? : insurance sales
What is the client no of SAND BOX.GOLDEN CLIENT, UNIT TESTING,ENDUSER TRAINNING AND PRODUCTION SERVER?????
please send previous exams question papers
Plz if anybody has placement paper of HAL mail me i m Chemical engg my id er.kotnala@gmail.com