6/4/2015
UpdateStrategyTransformationinInformatica
Home
DataWarehouse
Informatica
InformaticaScenarios
Oracle
Unix
Hadoop
Subscribe
UpdateStrategyTransformationinInformatica
[Link]
transformationisusedtoinsert,update,[Link]
Search...
Search
PopularPosts
SedCommandinUnixandLinuxExamples
[Link],youneed
todecidewhatdatashouldbestoredinthetarget.
Whenyouwanttomaintainahistoryorsourceinthetargettable,thenforeverychangein
thesourcerecordyouwanttoinsertanewrecordinthetargettable.
Whenyouwantanexactcopyofsourcedatatobemaintainedinthetargettable,thenifthe
TopExamplesofAwkCommandinUnix
FindCommandinUnixandLinuxExamples
CutCommandinUnix(Linux)Examples
sourcedatachangesyouhavetoupdatethecorrespondingrecordsinthetarget.
InformaticaScenarioBasedInterviewQuestionswith
AnswersPart1
[Link]
StringFunctionsinHive
informatica,youcansettheupdatestrategyattwodifferentlevels:
SessionLevel:Configuringatsessionlevelinstructstheintegrationserviceto
eithertreatallrowsinthesameway(Insertorupdateordelete)oruseinstructions
codedinthesessionmappingtoflagfordifferentdatabaseoperations.
MappingLevel:Useupdatestrategytransformationtoflagrowsforinert,update,
deleteorreject.
FlaggingRowsinMappingwithUpdateStrategy:
Youhavetoflageachrowforinserting,updating,[Link]
theirnumericequivalentsforeachdatabaseoperationarelistedbelow.
SQLQueriesInterviewQuestionsOraclePart1
DateFunctionsinHive
TypesofDimensionsindatawarehouse
GrepCommandinUnixandLinuxExamples
HaveQuestions?FollowMe
vijaybhaskar
Addtocircles
DD_INSERT:[Link].
DD_UPDATE:[Link].
DD_DELETE:[Link].
DD_REJECT:[Link].
Theintegrationservicetreatsanyothernumericvalueasaninsert.
UpdateStrategyExpression:
Youhavetoflagrowsbyassigningtheconstantnumericvaluesusingtheupdatestrategy
[Link]
updatestrategytransformation.
339havemeincircles
Viewall
Eachrowistestedagainsttheconditionspecifiedintheupdatestrategyexpressionanda
[Link]:
IIF(department_id=10,DD_UPDATE,DD_INSERT)
MostlyIIFandDECODEfunctionsareusedtotestforaconditioninupdatestrategy
transformation.
UpdateStrategyandLookupTransformations:
[Link]
sourcequalifieriscomparedwithrowfromlookuptransformationtodeterminewhetheritis
[Link],therowisflaggedtoinsertor
updateusingtheupdatestrategytransformation.
UpdateStrategyandAggregatorTransformations:
Ifyouplaceanupdatestrategybeforeanaggregatortransformation,thewaytheaggregator
[Link]
example,ifyouflagarowfordeleteandthenlaterusetherowtocalculatethesum,thenthe
[Link],thenthe
[Link]
1/2
6/4/2015
UpdateStrategyTransformationinInformatica
aggregatoraddsitsvaluetothesum.
ImportantNote:
[Link]
primarykeyavailableonthetargettable,thenyouhavetospecifyaprimarykeyinthetarget
definitioninthemappingforupdatestrategytransformationtowork.
RecommendedReading:
UpdateStrategySessionLevelSettings
SQLTransformation
InformaticaScenarios
UpdateStrategyTransformationinInformatica
StoredProcedureTransformationinInformatica
LookupTransformationinInformatica
Ifyoulikethisarticle,thenpleaseshareitorclickonthegoogle+1button.
NewerPost
Home
pnrstatus
[Link]
OlderPost
privacypolicy
2/2