Can we use MVC instruction to move pack field to pack field....which instruction you will use and why ?
4 10688There 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 6948The 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 6678If 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 20025If 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 496301rec1. 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 11596Where 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 16442If 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 6100Post New Amdocs Interview Questions
For how much time F-1 vissa is valid?
how many mobile subscriber are come under one BTS?? and how many BTS Comes under One BSC?? how many BSC under One MSC??
What are the different functions of each of the layer in TCP/IP model? What are the protocols associated with each layer?
How do I connect to a database in mysql workbench?
What is the spark driver?
What is the difference between global send keys and global send key events?
What is happening with public folders?
You need to debug a sapscript. How would you do that?
Explain what is a logical database?
What is the work of tranwrd function?
why we can use 1 to 5V dc
How to create Reusable and Multiple Actions?
Why do we use message queue?
Explain what does the burn down charts shows?
What is htpasswd?