What is checksum termnology in informatica? Where do you use
it ?

Answer Posted / vikas

Checksum used to cretae unique columns in table when u
implement checsum on any field in table during load time
then it will automatically find the max value of the field
and add 1 for every next record inserted. basically used i
SCD to create Index.

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

771


Explain informatica architecture - version 8 / 9

655


Difference between Data and Index Caches?

643


How many transformations can be used in mapplets.

1443


How an expression transformation differs from aggregator transformation?

615






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

619


Explain dynamic target flat file name generation in informatica

637


Under what conditions selecting sorted input in aggregator will still not boost session performance?

622


What is informatica worklet?

597


Enlist some properties of sessions.

610


Can u generate reports in Informatica?

647


In informatica workflow manager, how many repositories can be created?

769


Write the unconnected lookup syntax?

645


What's the layout of parameter file (what does a parameter file contain?)?

1906


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1724