Right Answer: Active transformations change the number of rows that pass through them or modify the data in a way that affects the flow of data, such as filters or aggregators. Passive transformations do not change the number of rows or the flow of data; they only modify the data values, such as expression or lookup transformations.
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.
Ques:- IN A ROOM THERE IS ONE BULB OUTSIDE F THE ROOM THERE ARE THREE SWITCHES ONLY ONE SWITCH IS CONNECTED THE BULB.YOU ARE ALLOWED TO STAND NEAR THE SWITCH FOR 5 MINUTES WHAT EVER YOU DO THE SWITCH.AFTER 5 MINUTES ENTER THE ROOM AND TO SAY WHICH IS THE CORRECT
Right Answer: Turn on the first switch and leave it on for 5 minutes. After 5 minutes, turn it off and turn on the second switch. Enter the room:
- If the bulb is on, the second switch is the correct one.
- If the bulb is off but warm, the first switch is the correct one.
- If the bulb is off and cold, the third switch is the correct one.
Right Answer: NLS (National Language Support) in DataStage is used to handle multilingual data and ensure proper character encoding. It allows for the processing of data in various languages and character sets, enabling users to work with international data seamlessly. The advantages include improved data accuracy, better user experience for non-English speakers, and compliance with global data standards.
