Can any body tell about the (UTC) unit
test cases with the examples in informatica.
Answer Posted / praveen kumar pendekanti
Take 10 rows (use rownum<11 in session sql override) copy
that 10 rows and paste in excel sheet then run the session
there by we will get output as 10 rows then check that we r
getting 10 rows same as source and also check the business
logic and date conversions(carefully) if all these r
getting correctly there by capy that 10 rows from the
target table and paste that rows in excel sheet....
Dont forget to take paste the sql override query in excel
sheet and finally take the session log of that session and
add that one in excel sheet.......
very important don't override in mapping source qualifer ok
if i am wrong let me know
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain in detail about scd type 1 through mapping.
EXL informatica Questions
draw informatica architecture 8.6 ?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is dimensional table?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Write the unconnected lookup syntax and how to return more than one column.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to create the source and target database connections in server manager?
Explain scd type 3 through mapping.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?