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
- 16371 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 |
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
Explain reference cursor?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
why we use datawarehouse
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
Explain about Recovering sessions?
What is the Router transformation?
How to do the error handling of if ur source is flatfiles?
what is the difference between informatica6.1 and infomatica7.1
Teradata 
