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
- 16050 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 |
How to update records in Target, without using Update Strategy?
What are parallel querys and query hints?
What is source qualifier transformation in informatica?
Name 4 output files that informatica server creates during session running?
Explain scd type 3 through mapping.
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
How to Create a folder using pmrep command?
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
What is the difference between Bitmap and Btree index?
Teradata 
