What is checksum termnology in informatica? Where do you use
Answers were Sorted based on User's Feedback
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|
Answer / krishna
Its a validation rule If the data is altered outside the
company firewall, the checksum will automatically detect
the violation and deny validation of the data
|Is This Answer Correct ?||12 Yes||7 No|
Answer / chitta acharya
Specify whether you want the PowerChannel Server to
calculate checksum for the file transfer. Enter "yes" to
enable checksum. Enter "no" to disable checksum. If you do
not enter a value for checksum, PcCmd uses the default
checksum value in the PcCmd.properties file.
|Is This Answer Correct ?||2 Yes||6 No|
what is the difference between lookupoveride and joiner?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
How to send duplicates to one target and unique rows to one target?target is empty
Which is better performance wise database or file?How?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
Define the various join types of joiner transformation?
What are 2 modes of data movement in Informatica Server?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
What are the main features of Oracle 8i with context to datawarehouse?
WHAT IS FACT TABLES?