Hi all, iam new to informatica, can anyone tell me
what is unit testing & how it is done?
thank u
- 3 Answers
- 12126 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gaurav
Unit testing is a process where u would be testing ur
application or mapping by taking sample data to check if it
satisfies the business rules.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sri ram
You can do unit testing by testing your mapping
1.develop the mapping,take target as a .csv file(if the
target db location is remote)
2.give some input satisfying business rules
3. check whether the output is generated appropriately
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shaik
Unit Testing is one of the testing process to provide some
sample data (hard coded data some times) to ensure your
logic is working as expected.
Talking Unit Testing specific to Informatica this is how I
did :
1. Generate a reference table from a .csv file on
Informatica Analyst.
2. Generate a profile using this Reference table( when ever
a reference table is creared a corresponding sql table is
created in the provided db during configuration)
3. Apply your rule (mapplet) on your profile and check if
you get the expected results.
4.You can add /remove data in the reference table to check
various scenarios.
| Is This Answer Correct ? | 2 Yes | 1 No |
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What are the features of complex mapping?
How big was your fact table
hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.
how u know when to use a static cache and dynamic cache in lookup transformation.
can we load the data with out a primary key of a table? what is target plan?
How does a sorter cache works?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
What is union transformation in informatica?
How can you change from reusable session into non-reusable session.
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
Differentiate between joiner and lookup transformation?
Teradata 
