DSXchange

I would prefer a FTP then a load rather than NFS. If for some reason the network goes down or something wrong happens to the NFS during loading , would have an adverse impact where as a file can be FTPed again if the nework goes down in between transfering.

Zac,
When dealing with large data for aggregation a good way is to set the method as "sort" and sort records just before the aggregate stage.

Hi,
In our project we are using the db2 load utility from the Datastage server itself to load Data to DB2 DB, its working fine. The only thing you need is DB2 client installed on Datastage server.
Why do you need to FTP datafile to DB2 Server ?

Hi All,

What would be an ideal condition for using sparse look up and when should we avoid the temtation of using it.

Hi All,

What would be an ideal condition for using sparse look up and when should we avoid the temtation of using it.

use DB2 EE stage for extraction, which would definitely be very fast as it retrives data on all the different nodes from DB2.
Also check the DB2 join you are doing ask your DBA to check how costly is the join. Joins can be expensive on if not executed properly.

Thank you everybody ......

Hi, We have source as flat file and have to load another flat file and have to transform a field which would be picking a substring. Its like picking a substring in a DB2 table using function substr(column,3,5) , which would give be a substring from character 3 to character 5 of the string. Do we ha...

are there any lab offered at this part of the World (India)
I think we have lot of people here who would be intrested in attending.

check if the project is protected ?

There is something seriously wrong .... i need to do an investigation.

Hi
Can you pl check at the server if its creating a file name with current date-time when you use
output`date +"%Y%m%d_%H%M%S"`.txt
i.e it creates a file name as "output20060713_201435.txt"

or its just creating a file with name :

output`date +"%Y%m%d_%H%M%S"`.txt

well I can create a file at the same path using touch command.

Hi, I'm geting the following error at runtime when I use : output__#DSJobStartDate#_#DSJobStartTime#.txt Sequential_File_2: When processing argument -fileWhen processing path: /home/dsetl01/my_prg/tmp/output_2006-07-13_19:23:44.txt is not a valid path name: Invalid hostname: /home/dsetl01/my_prg/tmp...

DSguru2B wrote: Thats why i gave an alternative solution without any space in between.

The alternative solution without space also throws the same error