Is union transormation is active transformation?



Is union transormation is active transformation?..

Answer / Lakhan Singh Meena

No, a UNION transformation in Informatica PowerCenter is not an active transformation. Active transformations (like Lookup, SQL, or Aggregate) perform computational operations on data, while the UNION transformation combines rows from multiple sources into one result set without performing any other operations.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

How can we run the graph?

1 Answers  


Explain the data types present in bo n wht happens if we implement view in the designer n report?

1 Answers  


Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

1 Answers  


How to reduce warnings?

1 Answers  


Name at least three brands of Database Management Systems

1 Answers  


Explain difference between snow flake and star schema.

1 Answers  


Where the cache files stored?

1 Answers  


How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

1 Answers  


What are the design methods of data warehousing?

1 Answers  


Explain Process flow in data warehouse??

1 Answers   BirlaSoft,


What are the steps to build the datawarehouse?

1 Answers  


What is the difference between a data warehouse and a data mart?

15 Answers   Apex, ASD Lab, Bank Of America,


Categories