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
- 16119 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 |
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
how many types transformations supported by sortedinput?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
can every transfomation reusable?how?
How to improve the performance of a session using sorter transformation?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
What is the scenario which compels informatica server to reject files?
Where can we find the throughput option in informatica?
How we can use union transformation?
Different types of Power center errors?
what we require for D.modelling?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
Teradata 
