1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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 ?

Question Posted / dharmendra13singh

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

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

2 Answers  

generate date / time dimension in informatica

0 Answers   Informatica,

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

0 Answers  

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

0 Answers  

Define mapplet?

0 Answers  




How do you take back up of repository?

0 Answers  

Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.

0 Answers  

which one is better performance wise joiner or look up

0 Answers   Informatica,

What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,

what are the types of Data warehousing ?

1 Answers  

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

3 Answers   Amazon,

For more Informatica Interview Questions Click Here
Categories