Answer Posted / venkatesh k
by backtracking the issue from target to source
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the types of lookup transformation?
Explain sessions?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to extract sap data using informatica?
Which transformation should we use to normalise the COBOL and relational sources?
What is rank transformation?
How do you load alternate records into different tables through mapping flow?
Explain the different lookup methods used in informatica?
Explain about Informatica server process that how it works relates to mapping variables?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How do you load only null records into target? Explain through mapping flow.
Write the unconnected lookup syntax and how to return more than one column.
