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

What is the benefit of session partitioning?

0 Answers  


when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,


How do you migrate data from one environment to another?

0 Answers  


1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

0 Answers   CTS,


if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,


How to update records in Target, without using Update Strategy?

3 Answers  


on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,


What is the need of etl tools?

0 Answers  


What is rank transformation in informatica

0 Answers   Informatica,


what is diffrence b/w joner and union transfermation

6 Answers  


Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  


What is the difference between a table and the materialized view?

2 Answers  


Categories