Answer / 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.

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

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.

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---

What is the difference between a connected look up and unconnected lookup?

0 Answers  

---

explain abt union t/r?

1 Answers   IBM,

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---

What is power center repository?

1 Answers  

---

which transformation uses cache?

3 Answers   Keane India Ltd,

---

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

---

What is a sequence generator transformation?

0 Answers  

---

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

---

what are the types of facts with Examples?

3 Answers  

---

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

---