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 4641
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 4779
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 15415
What is the role of informatica in project ?Like i showed financial projects?1 1160
Why we require dwh in particular projects?1 3043
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 12495
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 4315
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 22646
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?1 2358
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 4057
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.3 8941
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile2 4082
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 4113
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 6212
What are the standard profile options for oracle service contracts?
How can you export a component’s internal parameters ?
1. How can u know that the DB has connected to ur WLS? 2. What happen when u deploy a ear file in web applications? 3. What happen when ur DB and proxy server(Apache) are down n ur weblogic server is up? 4. How can u configure ur proxy server(Apache)? 5. How can the proxy server(Apache) communicate with ur WLS? 6. How the request process to ur WLS through the Proxy server(Apache)? 7. How can u know that ur heap memory is full? 8. When will u do garbage collection?
What is overflow and how it's happen
Detail description of the Reducer phases?
I am getting the "test object property" Description properties "toolkit class" value By using "gettoproperty" in run time But my problem is how to get Ordinal Identyfier's type and value Type is index, value is 0 How can i keep this values in to required place How can i get these values in runtime I have to insert these "index" and "value" into another area Is there any script for this like "gettoproperties","Getroproperties" If anybody knows,please help me .
how many type of plug are used in pneumatic control valve,name them.
i didnot recieve my group1 hallticket
What is the difference between single core 2 wire and single core 3 wire system? Which application we are using this? and for What purpose we are using this?
how to CHECK CT AND PT AT THE FAULT OCCUR IN GENERATOR RELAY PANEL .
what is study design in while working with SAS? what are screening variables in SAS?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
how to calculate the distance relay faulty zone?pls explain?
what is try_catch block in procedure
Write a corrected statement in c++ so that the statement will work properly. if (4 < x < 11) y=2*x;