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

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,


How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,


What is a data modeling?

2 Answers  


Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,


What is router transformation

4 Answers   CSC,


hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,


In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,


Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,


Which is the best place to learn Informatica Powercenter Online Training?

1 Answers  


What is informatica powercenter repository?

0 Answers  


Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,


What are the types of data warehouses?

0 Answers   Informatica,


Categories