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 many ways can we implement SCD2?

Answer Posted / kumar raja kotakonda

1) FULL HISTORY
2) DATE RANGE
3) VERSINING
4) FLAGING

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is expression transformation?

1142


Explain about Informatica server process that how it works relates to mapping variables?

1122


Whats the difference between informatica powercenter server, repositoryserver and repository?

1216


what is mean by complex business rule ?

2216


How to convert multiple rows to single row (multiple columns) in informatica

1423


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1118


CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9286


Where are the source flat files kept before running the session?

1137


Explain lookup transformation in informatica

1122


How can we create index after completion of load process?

1162


What is native users?

1217


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

1180


What is the Rank index port in Rank transformation?

1102


State the limitations where we cannot use joiner in the mapping pipeline?

1104


How do you load alternate records into different tables through mapping flow?

1924