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 4461
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 4608
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 14845
What is the role of informatica in project ?Like i showed financial projects?1 1053
Why we require dwh in particular projects?1 2917
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 12102
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 4139
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 21755
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?1 2228
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 indetail2 3936
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.3 8687
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile2 3979
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 3979
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 5981
How can we communicate as realistic a picture as possible of a job and of the organization to prospective employees? What kinds of issues are most crucial to them?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the causes if one cylinder in a diesel engine has a high temperature?
How to shut down and overhaul the centrifugal pumps?
EXPLAIN THE TERMS OF ANY RECENT MERGER WHICH HAD TAKEN PLACE IN INDIA.
In automation process timer based automation is best or not? any other possible methods are available
Making delivery challan is possiable between two branch of difference code
Tell me about women empowerment
hey.. what do you know about HSBC??
Calculate debtors at the end of the year? debtors-50000, bad debts-2000, discount allowed-1000, 5% on bad debt, 2% discount allowed?
what is the difference between a decision statement and ea loop statement?
can anyone tell me what is Game testing online casino Slot machine any sample test cases or scenarios
Comments Elements in accounting
what can increase gearing?
can we use dynamic send port without castration in biztalk