How to create a Excel file with multiple worksheets within a workbook using DataStage?

How to read a server job sequential file in parallel job sequential ..?Records getting dropped.

What is the limit of the file size? Is there any limit from # of rows and # of field perspective for file extract to be fed in profile stage?

Can "Readers per node" be set for both fixed and variable length files?

How to skip rows while reading from a sequential file?

How to convert a string to date by using only sequential file stage with out using other stages?

How would you dynamically name the sequentially file?

One Table have three columns like CUSTID, CNAME, LOC . We have "n" no.of Customers from different LOC. I Dont Know LOC Contains how many rows. But we Want CUST data, in sequential files LOC Wise. The sequential file names must contains with LOC Name.

Explain the significance of environment variable $APT_IMPORT_BUFFER_SIZE?

What is sequential file pattern reads? How does it impacts the performance of a job where sequential file is used?

How would you output signed numeric values in the output?

Sequential file scenario:

If you have 100,000 records in source table and a million records in reference table. Then how to put a default value for non matching records in output?

Sequential File - How to get output from sequential file and database?

How to fetch just first and last record from DataStage sequential file?

What is the difference in "Read by multiple nodes" and "Number of readers on single node"?

Can you read a XML file and put populate the information in a table? If yes, please explain?

What is the difference between Hashfile and Sequential File?

Subscribe to: Posts (Atom)