Search found 3 matches

by Harshagks
Tue Aug 12, 2008 2:24 am
Forum: General
Topic: Hash files
Replies: 2
Views: 1619

Hash files

Hi,

Can anyone explain me what is a Hash file with an example.
How many types are there and how to implement them?
Also the advantages and limitations.

Regards,
Harsha
by Harshagks
Mon May 26, 2008 6:24 am
Forum: General
Topic: Using of ROUND function
Replies: 4
Views: 2629

Using of ROUND function

Hi, I want to implement a ROUND function to get a value. Like, TOTAL AMOUNT = ROUND(Conversion Rate * Amount,4) Example: Conversion Rate = 1.234564 Amount = 56 TOTAL AMOUNT = 69.135584 but after the ROUND operator the value sholud be 69.1356. How can this be implemented in the Datastage?
by Harshagks
Wed May 14, 2008 11:58 pm
Forum: General
Topic: Declaring constants
Replies: 3
Views: 1544

Declaring constants

Hi,

There is a requirement where i need to use a constant to declare the number of weeks. How can this column be populated as this needs to be used in a transformer with the incoming columns of source?