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
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain sessions?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to configure mapping in informatica?
What is the function of aggregator transformation?
Which is the t/r that builts only single cache memory?
Have you worked with/created Parameter file
How to handle decimal places while importing a flatfile into informatica?
Differentiate between router and filter transformation?
Does an informatica transformation support only aggregate expressions?
How to load the data from a flat file into the target where the source flat file name changes daily?
Differentiate between Load Manager and DTM?
Mention few power centre client applications with their basic purpose?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?