ZS Business Technology Analyst Interview Questions, Process, and Tips

Informatica Transformations are used to manipulate data during ETL process.

• Aggregator: performs calculations on groups of data

• Filter: filters rows based on a condition

• Joiner: joins data from two sources based on a common key

• Lookup: retrieves data from a database table or flat file

• Rank: assigns a rank to each row based on a specified column

• Router: routes data to different targets based on a condition

• Sorter: sorts data b...read more

SCD stands for Slowly Changing Dimensions. It is a technique used in data warehousing to track changes in data over time.

• Type 1 SCD: Overwrite the old data with new data. Example: Customer address change.

• Type 2 SCD: Create a new record for the change. Example: Employee promotion.

• Type 3 SCD: Create a new attribute to store the change. Example: Product price change.

• Type 4 SCD: Create a separate table to store the change

Dynamic lookup is done at runtime while status lookup is done at design time.

• Dynamic lookup is used when the lookup values are not known at design time.

• Status lookup is used when the lookup values are known at design time.

• Dynamic lookup requires more processing power as it is done at runtime.

• Status lookup is faster as it is done at design time.

• Example of dynamic lookup: retrieving a list of available payment methods fr...read more

To maintain knowledge transfer of project/jobs developed, ensure documentation, training, and continuous communication.

• Document all project/job details, processes, and procedures.

• Provide training sessions to transfer knowledge and skills.

• Encourage continuous communication and collaboration among team members.

• Establish a knowledge sharing platform or repository.

• Conduct regular knowledge transfer meetings or workshops.

• As...read more

Fact and dimensions are components of a data warehouse. Facts are numerical data while dimensions are descriptive data.

• Facts are quantitative data that can be measured, such as sales revenue or number of customers.

• Dimensions are descriptive data that provide context for the facts, such as time, location, or product.

• Facts and dimensions are stored in a data warehouse, which is a large repository of data used for analysi...read more