Find Interview Questions for Attunity

Right Answer:
The SQL Server 2005 modules that cannot be signed with a digital signature are the system stored procedures.

Right Answer:
An Inner Join returns only the rows that have matching values in both tables, while a Full Outer Join returns all rows from both tables, with matching rows from both sides where available, and NULLs where there are no matches.

Right Answer:
The various transformations available in ETL include:

1. **Filter** - Removes unwanted data.
2. **Join** - Combines data from multiple sources.
3. **Aggregate** - Summarizes data (e.g., sum, average).
4. **Sort** - Orders data based on specified criteria.
5. **Lookup** - Retrieves related data from another table.
6. **Union** - Combines data from multiple datasets into one.
7. **Pivot** - Transforms rows into columns.
8. **Denormalization** - Combines tables to reduce complexity.
9. **Data Type Conversion** - Changes data types for compatibility.
10. **Expression** - Applies calculations or transformations to data fields.

Right Answer:
A three-tier data warehouse architecture consists of three layers:

1. **Bottom Tier**: The data source layer where data is collected from various sources (like databases, flat files, etc.).
2. **Middle Tier**: The data integration layer where ETL (Extract, Transform, Load) processes are performed to clean, transform, and load data into the data warehouse.
3. **Top Tier**: The presentation layer where users access and analyze the data through reporting tools and dashboards.

Right Answer:
Informatica Metadata refers to the data that describes other data within the Informatica environment, including information about data sources, transformations, mappings, workflows, and sessions. It is primarily stored in the Informatica Repository Database.

Right Answer:
GET is used to retrieve data from a server, POST is used to send data to a server to create a resource, PUT is used to update an existing resource on the server, and DELETE is used to remove a resource from the server.

Right Answer:
An API Gateway acts as a single entry point for clients to access multiple microservices, handling requests, routing them to the appropriate services, managing authentication, rate limiting, and aggregating responses.

Right Answer:
API versioning is the practice of managing changes to an API by assigning version numbers to different iterations of the API. It is important because it allows developers to introduce new features or make changes without breaking existing client applications that rely on older versions, ensuring backward compatibility and a smoother transition for users.

Right Answer:
CORS, or Cross-Origin Resource Sharing, is a security feature implemented by web browsers that allows or restricts web applications from making requests to a domain different from the one that served the web page. It affects API development by requiring developers to configure their APIs to specify which origins are allowed to access their resources, ensuring that only trusted domains can interact with the API.

Right Answer:
JSON (JavaScript Object Notation) is a lightweight data interchange format that is easy for humans to read and write, and easy for machines to parse and generate. In APIs, JSON is commonly used to format data exchanged between a client and a server, allowing for structured data representation in requests and responses.

Right Answer:
"In one project, we underestimated the complexity of integrating a new third-party API. This caused us to miss our sprint goal. To address this, we immediately re-estimated the remaining work, broke down the integration into smaller, more manageable tasks, and increased communication with the API vendor. We also temporarily shifted team focus to prioritize the integration, delaying a lower-priority feature for the next sprint. Finally, in the sprint retrospective, we implemented a better vetting process for third-party integrations to avoid similar issues in the future."

Right Answer:
* **Epic:** A large, high-level user story that is too big to complete in a single iteration. It's usually broken down into smaller user stories.
* **User Story:** A small, self-contained requirement that represents a valuable piece of functionality for the end-user. It follows the format: "As a [user type], I want [goal] so that [benefit]".
* **Task:** A small, actionable item that needs to be done to complete a user story. It's a technical breakdown of the work required by the development team.

Right Answer:
* **Clear Sprint Goals:** Define specific, measurable, achievable, relevant, and time-bound (SMART) goals for each iteration.
* **Daily Stand-ups:** Facilitate short, focused daily meetings to identify roadblocks and coordinate efforts.
* **Sprint Backlog Management:** Keep the sprint backlog refined, prioritized, and realistic based on team capacity.
* **Timeboxing:** Adhere to time limits for meetings and tasks to prevent scope creep and maintain momentum.
* **Focus on Value:** Prioritize tasks that deliver the most business value within the iteration.
* **Remove Impediments:** Proactively identify and resolve obstacles that hinder the team's progress.
* **Limit Work in Progress (WIP):** Encourage the team to focus on completing tasks before starting new ones.
* **Continuous Feedback:** Regularly review progress, gather feedback, and adapt plans as needed.
* **Defined "Definition of Done":** Ensure a clear understanding of what it means for a task to be considered complete.
* **Team Collaboration & Communication:** Foster open and effective communication and collaboration within the team.

Right Answer:
Kanban focuses on visualizing workflow, limiting work in progress (WIP), and continuous flow. Scrum uses time-boxed iterations (sprints) with specific roles (Scrum Master, Product Owner, Development Team) and events (sprint planning, daily scrum, sprint review, sprint retrospective).

Use Kanban when you need continuous delivery, have evolving priorities, and want to improve workflow incrementally. Use Scrum when you need structured development with fixed-length iterations, have clear goals for each iteration, and benefit from team collaboration with defined roles.

Right Answer:
Scrum is an Agile framework for managing and completing complex projects.

Implementation involves:

1. **Roles:** Defining roles like Product Owner, Scrum Master, and Development Team.
2. **Sprints:** Working in short, time-boxed iterations (Sprints), typically 2-4 weeks.
3. **Artifacts:** Using artifacts like Product Backlog, Sprint Backlog, and Increment.
4. **Events:** Conducting events such as Sprint Planning, Daily Scrum, Sprint Review, and Sprint Retrospective.
5. **Continuous Improvement:** Regularly inspecting and adapting the process based on feedback.