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...


SRC1 -> EXP -> AGGR ->
TGT
SRC2 -> EXP ->
Above is a maaping with two pipeline connected to the taret
TGT. Design wise is this design is correct or not ?

Answers were Sorted based on User's Feedback



SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping ..

Answer / srinivas

hi dahrmendra,

HOw can you join two pipeline or two branches of single
pipeline to single target.

even in place of tgt if you have any active or passive t/r
is presented tat mapping wouldnt be valid.but yes in place
of tgt you can use any multi input group t/r and connect it
to tgt then its valid

Is This Answer Correct ?    7 Yes 0 No

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping ..

Answer / dharmendra

Hi, Jeck.Thanks for the answer but could you please explain
me why keeping AGGR in 1st pipeline makes in invalid
mapping.Thanks in advance

Is This Answer Correct ?    2 Yes 0 No

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping ..

Answer / dharmendra

Hi Mahesh,
This is not the right place to do marketting.
Here we share our technical issues and resolve the same.
There are many other ways to attract people for your
institue.
Please do not repeat such malfunctioning.

Is This Answer Correct ?    3 Yes 1 No

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping ..

Answer / sarthak

If the column structure of the two pipelines are same...we
can use UNION t/f to pass data to single TGT instance

or

if we ll take 2 instances of TGT table.... then It ll be
correct...


else we can't connect two pipelines to single TGT instance
directly

Is This Answer Correct ?    1 Yes 0 No

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping ..

Answer / jack

Design wise it is not right. Since in the first pipe an
AGGR is there. It is not a valid mapping.

Is This Answer Correct ?    3 Yes 3 No

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping ..

Answer / sujatha

I think its wrong ...because aggr is an active trans and
exp is a passive trans....

as per the infa help ...
"You cannot connect an active transformation and a passive
transformation to the same downstream transformation or
transformation input group."....

Is This Answer Correct ?    4 Yes 4 No

Post New Answer

More Informatica Interview Questions

Which are the different editions of informatica powercenter that are available?

0 Answers  


ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,


what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,


How is Data Models Used in Practice?

1 Answers  


Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,


hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  


Is it possible to use a client with different version than that of its Informatica server?

0 Answers  


1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,


I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,


What is a transaction control transformation?

0 Answers   Informatica,


How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 Answers  


What are the types of maping wizards that r to be provided in Informatica?

2 Answers  


Categories