why union is active transformation?

Answer Posted / shobhan

if input number of rows are not equal to output number of rows, that would be Active transformation. In Union Transformation, input will more and output will be less. SO, this is a Active Transformation.

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

642


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1741


What is a joiner transformation and why it is an active one?

580


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1632


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1320






How to partition the Session?

648


How to generate sequence numbers without using the sequence generator transformation?

649


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1655


is it possible to index the data in cache of lkp transformation ?

1528


What is expression transformation?

637


How to join three sources using joiner?

575


What is the scenario which compels informatica server to reject files?

608


what is Active lock explain

2374


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1861


Explain pushdown optimization and types in informatica

672