i
TimesPro
Filter interviews by
posted on 30 Jan 2024
Top trending discussions
SQL query with join
Use JOIN keyword to combine rows from two or more tables based on a related column between them
Specify the columns to select from each table in the SELECT statement
Use ON keyword to specify the join condition
SQL query with join
Use JOIN keyword to combine rows from two or more tables based on a related column between them
Specify the columns to select from each table
Use ON keyword to specify the join condition
I applied via Referral and was interviewed before Apr 2020. There were 3 interview rounds.
I applied via Approached by Company and was interviewed before May 2021. There were 4 interview rounds.
Online questions were based on scenarios to write SQL queries. Also got few questions on Python as well for which I had only limited knowledge.
The source row will be treated as an update, but the target object will be deleted.
The session level property 'Treat source row as Update' will be applied to the source row.
The target object will be deleted regardless of the update status of the source row.
This can result in data loss if the source row contains important information.
Dimension tables are used in data warehousing to provide descriptive information about the data in fact tables.
Slowly changing dimensions
Junk dimensions
Degenerate dimensions
Role-playing dimensions
Bridge dimensions
We used a relational schema in our previous project as it was suitable for the data structure and allowed for efficient querying.
Relational schema was used as it allowed for efficient querying of data
The data structure was suitable for a relational schema
We were able to easily join tables to retrieve necessary data
Examples include using SQL to query a database with multiple tables
Normalization was used to reduce data r
Joiner combines data from multiple sources based on a common key, while Lookup retrieves data from a reference table based on a matching key.
Joiner is used to combine data from two or more sources based on a common key column.
Lookup is used to retrieve data from a reference table based on a matching key column.
Joiner can perform inner, outer, left, and right joins, while Lookup can only perform an inner join.
Joiner can...
We used Git for version control in our previous project.
We created a Git repository for the project.
All team members were added as collaborators to the repository.
We followed the Git flow branching model.
We used pull requests for code review and merging.
We used tags to mark important releases.
We regularly pushed our changes to the remote repository.
We used Git commands like commit, push, pull, merge, and rebase.
We used...
I have worked on SCD Type 2 before.
SCD Type 2 is used to track historical changes in data.
It creates a new record for each change and maintains a history of changes.
It includes start and end dates for each record.
Example: Tracking changes in employee salary over time.
I applied via Recruitment Consultant and was interviewed before Sep 2020. There were 4 interview rounds.
Accrual account is a type of account that records revenue or expenses that have been earned or incurred but not yet received or paid.
Accrual accounting recognizes revenue and expenses when they are earned or incurred, regardless of when the cash is received or paid.
Accrual accounts are used to record these transactions until they are paid or received.
Journal entry is the process of recording a transaction in the accoun...
Reconciliations involve comparing financial records to identify discrepancies and resolve them.
Reconciliations are important for ensuring accuracy in financial reporting.
The process involves comparing two sets of records, such as bank statements and accounting records.
Any discrepancies are identified and investigated to determine the cause.
Examples of reconciliations include bank reconciliations, accounts receivable re
I applied via Recruitment Consultant and was interviewed in Mar 2021. There were 3 interview rounds.
I applied via Naukri.com and was interviewed before Jan 2021. There were 3 interview rounds.
I applied via Referral and was interviewed in Feb 2020. There were 4 interview rounds.
based on 1 interview
Interview experience
Program Advisor
124
salaries
| ₹3.5 L/yr - ₹9 L/yr |
Assistant Manager
37
salaries
| ₹5.2 L/yr - ₹15 L/yr |
Counsellor
22
salaries
| ₹2 L/yr - ₹6 L/yr |
Business Development Manager
20
salaries
| ₹5 L/yr - ₹8.5 L/yr |
Sales Manager
18
salaries
| ₹2.4 L/yr - ₹4.8 L/yr |
Genpact
Taurus BPO Services
Brane Enterprises
QX Global Group