Woriking with Project sessions in TeraData

Project sessions

Project  – Collection of steps or process or an approach to

Implement task or operation or a business

(OR)

It is a process where set of tasks define and implement this task

With a standard model

EX – IT Project

Here the model is SDLC And the business operation is task

software Development life cycle – SDLC

If we implement this task by using this model then it is “IT”

Project

 

Screenshot_9

NFI[National From insurance] organization

 

Day to day operations(Source system)

2What are General metting happen in a project?

Ans

  1. Project Tender meeting(SLA)Service Level agreement
  2. KICK OFF Meeting[Project initial meeting/introduction meeting]
  3. Status/schedule Meeting(Weakly, daily)
  4. Delivery client Regular
  5. Delivery Meetingà Project MANAGER Meeting
  6. Team Meeting
  7. Clarification defect resolivation Meeting DeveloperàLeadàPMàClient
  8. Discussion Meeting

 

Development Responsibility

Documents in

  1. LLD/Micro Design/Source map/target 2 source/souce to target mapping etc.
  2. HLD
  3. CR(Change Request)
  4. Defect Tract sheet etc

 

Document out

  1. Generated code
  2. Unit test code results
  3. Defect Resolution steps
  4. HLD LLD

2What is HLD And What it contains?

Ans: HLD[High Level Design]

  1. It Display the scope and various sub components of corresponding tasks along with the relationship
  2. It is platform independent
  3. Generally Represented with Diagrams[either data flow/e-R Diagrams etc]

 

2What is LLD And What it contains?

Ans: Low Level Design[LLD]

It contains the below information

  1. Source and its structure
  2. Destination and its structure
  3. Source to Destination business or mapping Rules
  4. To Develop the coding this document Required[Generally Developer use this documents]

 

 

 

23)Most of the organization there maintained LLD Document in excel sheet very few organization in word Doc Format

Ans:  What is mean by unit testing, who is Responsible for that How do you do that?

  1. Testing individual unit of code is called unit testing
  2. It is Responsibility of Developer
  3. Generally we are keeping unit test cases and Result in separate work sheet of excel sheet

 

 

Screenshot_10

 

2Explain various testing phases in our project?

Ans:

a)Unit test:

  1. This can also be called white box testing
  2. Individual unit of code tested here
  3. It is developer responsibility

b)System testing[Functional/block box test]

  1. The functionality of the component tested here
  2. It is Responsibility of quality analyst(tester)
  3. User accepting and testing(UAT) End user Testing

Other testing

  1. Silk Testing
  2. Regression Testing
  3. Integration testing

 

2What is the project life cycle model your using project describe me the steps?

Ans: We are using water fall model other models

V Model

Agile model     Frequently used in real time

Spiral model

Rapid model

Increment model

Etc.

 

Steps

  1. Requirement Gathering
  2. Analysis
  3. Design
  4. Coding
  5. Testing
  6. Implementation and maintained
  7. SLA Support

SLA=Service Level Agreement

 

2What is your data ware house model and Approach?

Ans: Our model is “3NF”

[Other models STAR SCHEMA, Snow FLAKE SCHEMA,INTEGRATED SCHEMA etc ]

àData ware house approach is Top down Approach[WMON Approach]?

Ans: Top down Approach

 

2How Do you Get the input file what are there size?

Ans:

  1. Generally we are Getting flat file and client keeps the file in shared derive/location on the server
  2. This file sizes are range MBs To GB

2How do you Get Document HLD,LLD Business etc interview project?

Ans: In my old project we use to get the document through mail in my current project we use to getting from the share point server by using user id, and password

 

2What do you mean by source system and tell some of source system name?

Ans: It is a name Given to a particular process where the data source in database, this system are input to the  were house

EX: LA(Life ASIA)

AMS(AGENCY MANAGEMENT system)

PAY+

WEGA

Gold Mind

ETC

Note

Do not use the above names in interviews, instead use your corresponding project source system names

It do not the name create/add/put your own name

 

2What is staging area and how it help for us? where do you have the staging in your project?

Ans

  1. An intermediates storage area also be called as stage area.
  2. Generally in between OLATP System data ware housing we have the staging area.

Here having  2 staging in my project

  1. At operating system level Unix
  2. At data ware house system level in tera data

 

 

 

 

2What are the scheduling tools your using in your project, how are doing scheduling?

Ans: As Developer I am not doing that, my onsite counter part is doing the scheduling.

I heard that they are using, CONTROL-M, for this scheduling

 

Other scheduling tools

Auto sys

$U.

TRILLIUM, CRONTab, AT Commands in union

 

 

2How are you maintaining versioning in  your  project?

Ans: We are using PVCS for maintaining Version

PVCS – P Version control system

Other version Tools:

CVS;

VSS=Visual source safe

Clear case.

Quality center etc

 

Screenshot_11

 

Version

Doc name

creation/conducting modify write date

Description

 

1Abc.txtVinay,15 Nov 2011Initial Release change date
2Abc.txtMadhu,16 Nov 2011LLD322

 

 

Screenshot_12

 

Steps

  1. There is a scheduled process to get the day to day data from the source system to Unix stage server
  2. From Unix stage to tera data stage actual operations are perform by using BTEQ,FL,ML Information, Data stage
  3. Once stage data base is ready now there is a load from stage 2 actual destination.
  4. During this load if there any exception there moving into error database
  5. Once target data base is ready the reporting people there generates cubes and creating various Reports from inure.

 

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Woriking with Project sessions in TeraData"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please leave a message and we'll get back to you soon.
    Three + 6