What is unit testing?
Divide the main components of graphs having required transformations and do data
validation for each of them separately.
How u gather requirements?
It is a team of 6 members, one is onsite coordinator and remaining is offshore
with our PL.
Daily we will have call with OSC for status update as well as getting new
requirements if any.
My PL use to divide the work based on requirements and will start preparing
the document according to the requirement and send it back for their
validation.
Once they confirm the requirement, we prepare test cases document for the
requirement and start doing the coding process i.e. preparing the graphs.
After coding process completion we do unit testing on graphs based on test
case document which have already prepared
After completion of our work we use to check-in the code into the EME
What are u r roles and responsibilities?
Interact with the client/OSC for the requirement gathering and status
update.
Analysis and documentation of provided requirement.
Preparing mapping for provided requirement.
We prepare the test cases document for the provided requirement.
Developing the Ab Initio and wrapper scripts.
Involved in unit testing and peer to peer testing the graphs.
We use do check-in and check-out for prepared code.
What happens when u run a graph?
About your project
The scope of my project is to build a data ware house by analyze the data
coming from the total system services.
This system consists of five to six different files to be loaded into to the database
for the staging and verification purpose.
In staging data will be check for the consistency and completeness and do some
business rules needed.
After completion of staging process, tables load the data elements needed for
data warehouse.
When the load has completed, the original files are archived off into the historical
tables.
This data warehousing is used for the querying into data warehouse or into
business objects universes for reporting.
How u connect the gde and cooperating system?
What documents u prepare for u r project?
What mapping document contains?
What hld contain and explain all of them?
What lld contain and explain all of them?
How to move code in developing to production?
Perform the following steps to move ur code from DEV EME to PROD EME.
1. Save the Graphs and Deploy the Graphs as Script. This will update ur
.ksh file.
2. Check in the Graphs and other necessary objects (dmls, xfrs.......).
This will put the updated things in the EME.
3. Create a tag (say xyz) for the graphs / dmls / xfrs that u want to move to other EME.
Use the command air tag create abc /Projects/DEV/ENV/mp/load_dw.mp
4. Create a .save file using the command --
Air save <.save file name> -from-tag <Tag name created in last step>.
5. Load the .save file in the PROD / QA EME using the following cmd -
Air load <name of .save file created in last step> -relocate <Dev
Project Path> <QA Project Path>.
Putting an example -- air load [Link]
-relocate /Projects/DEV/ENV /Projects/PROD/ENV
How to change dependence analysis in graph?
May be using psets
How u prepare analysis document?
Based on requirement doc
What analysis document contains exactly?
Here creating approach [Link] contains problem, analysis, solution, approach,
exceptions, performance tuning