Informatica - How can you say that union Transormation is Active transformation.

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 319 of 631

How can you say that union Transormation is Active transformation.

Total Answers and Comments: 9

Last Update: May 15, 2008 Asked by: manasa

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 22, 2006 07:26:42

kirankumarvema

RE: How can you say that union Transormation is Active...

By using union transformation we can eleminate some rows....so this is active transformation.bye

Is this answer useful? Yes | No

July 23, 2006 07:16:59

krishna

RE: How can you say that union Transormation is Active...

Pls explain more. we are doing the union.how the union is eliminating the some rows.

Is this answer useful? Yes | No

July 24, 2006 21:47:21

Bala

RE: How can you say that union Transormation is Active...

By Definiation, Active transformation is the transformation that changes the number of rows that pass through it...in union transformation the number of rows resulting from union can be (are) different from the actual number of rows.

Is this answer useful? Yes | No

July 26, 2006 06:53:01

dsr

RE: How can you say that union Transormation is Active...

union is active becoz it eliminates duplicates from the sources

Is this answer useful? Yes | No

July 27, 2006 08:56:59

manasa

RE: How can you say that union Transormation is Active...

Heloo Msr your answer is wrong.Union is not eliminating the duplicate rows.If anybody knows please give me reason. All are giving the above answers are not supporting that question.Don't give the active transofrmation defination.I want exact reasons.

Is this answer useful? Yes | No

July 31, 2006 16:00:22

srisailu

Member Since: July 2006 Contribution: 3

RE: How can you say that union Transormation is Active...

hi,

We can merge multiple source qualier query records in union trans at same time , its not like expresion trans (each row). so we can say it is active.

Is this answer useful? Yes | No

August 29, 2006 15:58:06

Uma Bojja

Member Since: May 2006 Contribution: 7

RE: How can you say that union Transormation is Active...

Hi,

Union Transformation is a active transformation because it changes the number of rows through the pipeline.

It normally has multiple input groups to add on it compare to other transformation.Before union transformation was implement the funda on number of rows was right i.e before 7.0 but now its not the exact benchmark to determine the active transformation

Thanks

Uma

Is this answer useful? Yes | No

September 25, 2006 08:00:43

Ravi

RE: How can you say that union Transormation is Active...

Hi,

Union also Active tranformation.because it eliminates duplicate rows

When you select distinct option in union properties tab.

Is this answer useful? Yes | No

May 15, 2008 04:04:48

h02kkvel

Member Since: May 2008 Contribution: 3

RE: How can you say that union Transormation is Active transformation.

Hi all,
some people saying that a union T/R eliminates duplicates. but it is woring . As of now it wont eliminate duplicates.

The union T/R is active and also passive depends upon the property "is active" which is present at union T/R properties tab. this Specifies whether this transformation is an active or a passive transformation. When you enable this option, the transformation can generate 0, 1 or more output rows for each input row. Otherwise, it can generate only 0 or 1 output row for each input row.

but this property is disabled in informatica 7.1.1. I think it may developed in future.

regards,
kiran

Is this answer useful? Yes | No

Go To Top