Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How union transformation is active ?

Answer Posted / priyank

As per the definition of the Active transformation, the no
of rows going in should be equal to the no of rows going
out.Besides that the row id of the input rows should be the
same the row id of the out going rows.

Henceforth, union transformation is true for the first
condition where the no of rows entering is same as the no
of rows going out as Union transformation treats rows for
UNION ALL condition. But in the second condition i.e. Row
id,there is no control on the rows which enter the Union
transformation from different sources so the Row id can
change.

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between informatica 7.0 and 8.0?

992


r u done any partitions in ur project?

1811


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2396


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

1142


As union transformation gives UNION ALL output, how you will get the UNION output?

1087


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1047


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2113


Quickly characterize reusable change?

1092


What are the guidelines to be followed while using union transformation?

1121


Please let me know how to make Data masking in informatica..

1699


Why do you use Mapping Parameter and mapping variable?

1743


What is update strategy transform?

1078


Mention few advantages of router transformation over filter transformation.

1019


What is the way to execute pl/sql script using informatica mapping?

1583


Explain what are the different versions of informatica?

1083