Data Warehousing Question: Download Questions PDF
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition.
Answer:
Informatica filter transformation default value is 1 i.e. true. If you place a break point on filter transformation and run the mapping in a debugger mode, you will find these values 1 or 0 for each row passing through filter. If you change 0 to 1, the particular row will be passed to next stage.
Download Data Warehousing Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is galaxy schema? | After we create a SCD table, can we use that particular Dimension as a dimension table for Star Schema? |