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

Define error Threshold?

1 Answers  

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

Enlist some properties of sessions.

0 Answers  

why we use stored procedure transformation?

4 Answers   IBM,

what is degenerated dimension table with scenario

2 Answers   HCL,

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

Enlist the differences between database and data warehouse.

0 Answers  

What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

For more Informatica Interview Questions Click Here
Categories