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


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

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

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,


What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,


i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,


How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,


How to call shell scripts from informatica?

0 Answers  


hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,


While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,


If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,


What is polling in informatica ?

1 Answers   TCS,


All active transformations r passive or not?

7 Answers  


how do u tune queries?

1 Answers  


Categories