HCLTech Datastage Developer Interview Questions and Answers

Join is used to combine rows from two or more tables based on a related column, while lookup is used to retrieve data from a reference table based on a matching key.

• Join combines rows from multiple tables based on a related column

• Lookup retrieves data from a reference table based on a matching key

• Join can result in duplicate rows if there are multiple matches, while lookup returns only the first matching row

• Join is use...read more

Fact table contains quantitative data and measures, while dimension table contains descriptive attributes.

• Fact table contains numerical data that can be aggregated (e.g. sales revenue, quantity sold)

• Dimension table contains descriptive attributes for analysis (e.g. product name, customer details)

• Fact table is typically normalized, while dimension table is denormalized for faster queries

• Fact table is usually larger in s

Use sed command to display the line before a specific pattern

• Use 'sed -n '/pattern/{g;1!p;};h' file.txt' to display the line before the pattern

• Replace 'pattern' with the specific pattern you are looking for

• This command will display the line before the pattern in the file