What is checksum termnology in informatica? Where do you use
it ?
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 are the types of maping in Getting Started Wizard?
how to design mapping half of source table records into one target and remaining half into another target
what is degenerated dimension?
What is the difference between Bulk Load and Normal Load
What is a pre-defined event and user-defined event?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
What is the function of look up transformation?
why normalizer transformation can not used in mapplet? plzzzz answer
How to create the source and target database connections in server manager?
Explain scd type 3 through mapping.
What is the Rank index port in Rank transformation?
What is sequence generator transformation in informatica?