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

HOW TO GET THE LATEST DATA IN SCD ?

Answer Posted / vikneswaran

in type 1 ... only the latest date... so it is very easy to get

in type 2.. to get by using date or flag or version

in type 3.. to get by selecting previous_column

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

expain about the tune parameters?

2415


How do you load unique records into one target table and duplicate records into a different target table?

1261


Target increases every day even though no new record was inserted

1581


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1864


What is pmcmd command?

1123


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6183


Why do you use Mapping Parameter and mapping variable?

1766


Explain the different lookup methods used in informatica?

1043


Is it possible to create multiple domains on a single Informatica server?

1243


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2185


can you please explain me pre session and post session options?

7570


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1905


Explain pushdown optimization and types in informatica

1079


What is the format of informatica objects in a repository?

1020


Explain about cumulative Sum or moving sum?

1043