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

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?

Question Posted / ranjan

Answers were Sorted based on User's Feedback



IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?..

Answer / divi

Alternative to Lookup id Joiner.we need to import source
structure of target in Source Analyser and bring that into
mapping and use it for comparison like Lookup.

Is This Answer Correct ?    10 Yes 2 No

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?..

Answer / krishna

In the sesion u hav to put update else insert

Is This Answer Correct ?    7 Yes 1 No

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?..

Answer / shashiall

plz..use "update else insert" in the properties of session.

Is This Answer Correct ?    5 Yes 0 No

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?..

Answer / saritha

You can use Joiner transformation to design scd Type1
manually. Import target as source and use joiner
transformation. Use expression to insert and update the
rows into target.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,

What is a standalone command task?

0 Answers  

what is difference between COM & DCOM?

1 Answers   Satyam,

How to display First letter of Names in Caps?

7 Answers  

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

what is mapping performence?

2 Answers   Cap Gemini,

What is the use of source qualifier?

0 Answers  

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

Why filter transformation is an active one?

0 Answers  

What is data transformation manager process?

0 Answers  

How will you update the row without using update statergy?

10 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories