Software Testing

Steps to Deploy the OFSAA application in WEBLOGIC server: ========================================================= 1) Generate the "context_name.ear" from the FIC_WEB area by executing the ./ant.sh 2) Create a folder by the name "applications" within the domain directory 3) Create a folder by the name "context_name.ear" within the newly created "applications" folder 4) Copy the context_name.ear file from the FIC_WEB folder to the newly create the "context_name.ear" folder created within the applciations folder 5) Explode the .ear file copied from the FIC_WEB area (jar -xvf context_name.ear), There are 2 files and 1 directory created after the .ear file is exploded as mentioned below a) context_name.war ---> file b) context_name.ear ---> file c) META_INF ---> folder 6) Delete the above files (.ear and .war files) 7) Create a new folder by the name "context_name.war" 8) Copy the context_name.war file from th

Please find the steps below for the OFSAA ALM cashflow generation. -------------------------------------------------------------------------------------------------------------- 0. OBJECT REGISTRATION 1. Create Product Hierarchy in front end.--- DIM_PRODUCTS_B 2. Create COA hierarchy in the front end. -- dim_common_coa_b 3. Map product members to COAs 4. Create one Legal Entity in the Front end. 5. Execute "Reverse Population" -- DT name : REVERSE_POPULATION 6. Create one Active Time bucket. 7. Populate DIM_DATE : Execute function "" in the back end with start date and end date. 8. Populate FSI_D_LOAN contracts 9. Create one product characteristic in ALM 10. Create one ALM Static Deterministic process for Loan data. 11. Execute from ALM Process. 12. Use the below queries for cashflow data. select /* + PARALLEL(16)*/ a.as_of_date, a.account_number, a.amrt_type_cd, a.int_type, a.origination_date, a.last_reprice_date, a.next_reprice_date, a.ma

1) Why are we able to see all other schemas along with the schema which we provided in the connection pool settings (odbc / OCI ) A: We will be able to see all other schemas along with the schema credentials which we provide, only when provided schema has a read / write permissions to the schemas available in that instance. 2) How will RPD get the number of records count even when we open RPD in offline and all the services are down. A: Through ODBC / OCI 3) Is Between operator supported by OBIEE when you create joins in RPD ? A: No 4) We have only 1 connection pool with "SCOTT" user but want to import tables from "HR" schema and view data. (Assuming SCOTT has read only permission to HR schema). A: We need to select the check box in connection pool settings "Require Fully Qualified Table Names" 5) Can you delete a parent table if you have created an alias table A: No,  Alias table has to be deleted first before deleting parent table 6)

select trunc(months_between(date2,date1)) months,        date2 - add_months(date1,trunc(months_between(date2,date1))) days   from (select to_date('25-Aug-2013','dd-Mon-yyyy') date1,to_date('23-Oct-2013','dd-Mon-yyyy') date2           from dual        ) MONTHS DAYS 1 28

Search with file extension in Windows Enter that from whatever directory you want to start. FOR /R will do the rest for every single file extension (*.xls) that’s in the descendants of the launching directory. for  /r %d in (*.xls) do echo %d >> c:\temp\Output.txt TimeSaver....!!!!