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

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

why cant we put a sequence generator or upd strategy
transformation before joiner transformation?

Question Posted / chandra

Answers were Sorted based on User's Feedback



why cant we put a sequence generator or upd strategy transformation before joiner transformation?..

Answer / srinivas

Joiner is to join two different sources .If u use Update
strategy T.F and trying to use DD_delete&DD_reject option
the some of the data will get deleted and u can't see the
at joiner output.
So we can't go for this .

Is This Answer Correct ?    5 Yes 7 No

why cant we put a sequence generator or upd strategy transformation before joiner transformation?..

Answer / bhupal

if you use the update strategy transformation before joiner in mapping, the mapping will be invalid because of data flow validation errors in mapping irrespective of operations you implemented in update strategy.

joiner transformation input should be from source qualifier transformation.

source---->sq--->seq--->
joiner---->trg
source---->sq---->

we cant create mapping like this because seq does't allows port to create and accept from other tr.

src--->sq--->
joiner--->trg
seq--->
we cant create like this. joiner inputs should be from source qualifier.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

what is lookup chache?

1 Answers   Patni,

What are the modules in Power Center

0 Answers  

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

What is a dimensional model?

0 Answers  

WHAT IS FACT TABLES?

2 Answers  

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

What are the advantages of informatica?

0 Answers  

What is a taget load order?

2 Answers   IBM,

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories