How do you answer scenario based interview questions?

How do you answer scenario based interview questions?

What to include in an answer to a situational interview question

1. Explain the situation. You’ll first need to explain the similar situation you’re using to answer the question before you get into what you did to solve it.
2. Describe the problem.
3. Outline the action you took to remedy the problem.
4. Talk about the results.

What is Informatica interview questions and answers?

Informatica Basic Interview Questions

• What do you mean by Enterprise data warehouse?
• What is ETL (Extract, transform, Load) and write some ETL tools.
• What is Informatica PowerCenter?
• Name different types of transformation that are important?
• Write the difference between connected lookup and unconnected lookup.

What is active and passive transformation in Informatica?

A transformation can be active or passive. An active transformation can change the number of rows that pass through the transformation. A passive transformation does not change the number of rows that pass through the transformation.

What are scenario based questions examples?

Five situational interview questions and answers

• What would you do if you made a mistake that no one else noticed?
• What would you do if you were asked to perform a task you’ve never done before?
• Tell me about a time when you failed.
• What would you do if an angry and dissatisfied customer confronted you?

What is workflow in Informatica?

A Workflow in Informatica is a set of multiple tasks connected with start task link and triggers the proper sequence to execute a process. When a workflow in Informatica is executed, it triggers a start task and other tasks connected in the workflow. A workflow is an engine which runs ‘N’ number of sessions / Tasks.

Why sorter is active transformation in Informatica?

Why is Sorter an Active Transformation? This is because we can select the “distinct” option in the sorter property. The number of Input Rows will vary as compared with the Output rows and hence it is an Active transformation.

How many types of transformations are available?

There are 3 Informatica transformations viz. External Procedure, Lookup, and Stored Procedure which can be unconnected in a valid mapping (A mapping which the Integration Service can execute).

How do you answer the interview question,?

How to Answer Interview Questions (When You Don’t Know The Answer) 1. Don’t BS 2. Admit That You Don’t Know 3. Explain What You Do Know 4. Explain How You’d Learn It 5. Point The Interview In The Right Direction Recently on Simplicable

How to answer the “tell me about yourself” interview question?

Mention past experiences and proven successes as they relate to the position. Begin by rereading the job description.

Consider how your current job relates to the job you’re applying for.

Focus on strengths and abilities that you can support with examples.

Highlight your personality to break the ice.

What are good questions to ask a job candidate?

Good questions to ask include inquiring about the company’s goals, and training and advancement opportunities. You can ask specific questions about the job, but don’t get too technical because you could be interviewed by someone in human resources who might not know all of the specific details of the job.

What are the question for the interview?

A key question to ask a potential employee at an interview is an introductory question. The introductory question is generally something like “What are your hobbies” or “Tell me about yourself.”. A good answer to this question will reveal the skills, accomplishments and traits of the candidate that relate to the position.