Interested to Buy Any Domain ? << Click Here >> for more details...
Can any body tell about the (UTC) unit
test cases with the examples in informatica.
- 4 Answers
- 16323 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shankar nm
Step 1. Have your valid mapping ready.
Step 2. Go to Debugger mode, set your breakpoints
Step 3. Activate view of target, output, input to ON
Step 4. choose View -> navigate to debugger, turn instance
data and target data ON by checking
Step 5. Use Func.Key or use mouse to go to next instance
check the output on target. follow the flow.
Alternate way is to check the SQL on TOAD to check the
number of rows meeting the criterion in each component.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / dilip
I want to more to whatever is above, for the unit test
cases try to validate your all the transformation rule e.g
to_date,null check, look up cases and the stubbing cases if
any in the mapping.
| Is This Answer Correct ? | 0 Yes | 0 No |
Describe expression transformation?
How you count the number of records available at your source?
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
how many types transformations supported by sortedinput?
What is the function of union transformation?
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
what are challenges that you faced in testing? give solution to it?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
what is galaxy repository?
What is the role of informatica in project ?Like i showed financial projects?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Teradata 
