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 need for an etl tool?
list out all the transformations which use cache?
How can we create index after completion of load process?
Can we change Dynamic to Static or Persistent cache? If so what happens?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is a snowflake schema?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Explain Dataware house architecture .how data flow from intial to end?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Can we create a Integration service without a Repository service and vice versa?
How do you promote a non-reusable transformation to reusable transformation?
draw informatica architecture 8.6 ?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is a node in Informatica?