Can we use MVC instruction to move pack field to pack field....which instruction you will use and why ?
4 12199There 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 7529The 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 7340If 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 21129If I want to initialize the array like. int a[5] = {0}; then it gives me all element 0. but if i give int a[5] = {5}; then 5 0 0 0 0 is ans. what will I do for all element 5 5 5 5 5 in a single statement???
3 605501rec1. 05 a pic 999v99 value 123.12 05 b pic 99v9 value 45.9 02 rec2. 05 x pic 999v99 05 y pic 99v99 05 z pic x(3) value 'abc' if rec1 is moved to rec2 then what is the value of rec2?
5 13259Where 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 17587If 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 6880Post New Amdocs Interview Questions
What is uncommon or interesting about the CALCULATE and CALCULATETABLE capacities?
How does css work under the hood?
What is a client in SAP terminology?
Draw the basic structure of an n channel junction field effect transistor.
how to fin top two miximum values in sql? not 2nd both max value of 1st and 2nd both have to find out
What is sns?
Explain how to convert binary to excess 3 code and vice verse?
a sewer which receives the discharge of no. of house sewer is called house sewer lateral sewer intrcepting sewer sub-main sewer
Search for: what is pair in c++?
What is the first character of the output in ls l command?
Can you rename columns in excel?
where do u maintain all your test cases in manual not in selenium
When we should use serialization?
What is the difference between session and entity beans? When should I use one or the other?
Mention what is the main difference between function and sub-procedure?