DSXchange

HI Keshav;

As I am using a user defined query , do i need to give table name ?

Thanks Ray

Hi all; I am facing a very strange problem . I am using a TERADATA API stage in a datastage job . In the API stage , I am using a USER-DEFINED SQL , where I am joing 3 tables and retriving the data. But when I am trying to view data from the SQL , that time the following error is coming."GENERA...

Thanks Very Much

I will create the Dat file in another PX job from some VIEWS of one Teradata Table and will be stored in my UNIX home , so from there we can get the TOC (time of creation ) of the dat file.

Sorry for posting in section;

It will be a PX job in DataStage 7.5.2

Hi all My requirment is as follows I have a seq file (let's say name of the file is "customer.dat" I wanna make 3 files from this file as follows : 1.customer.dat ----- which will contain all data of the parent file 2. customer.ctl------ which will contain record count , time of file gener...

Kris,

This is not clear for me , let me refresh my question again.

I am asking " Can I creat Terasync in any WORDB" ?

Can I create TeraSync in Work database?

ray.wurlod wrote:Imagine that the SELECT statement that defines the view selects 10 million rows, and when you select from the view you want only 10,000 of these.

Selecting from the view means that the first, large ...

Thanks Ray ......the info is really informative

ray.wurlod wrote:Yes. But the cost of materializing the view may be one that you wish to avoid. ...

Please tell me why Cost will be high?

Can Datastage 7.5.2 read views from Source tables?

xinhuang66 wrote:I have a big datastage job, it has a lot of category, sub-category, and son.

Somebody gave me a job name and ask me have a look.

I just couldn't locate it, somebody tell me how to search it ??

Thanks

Hi

You have to ask for Server and Project name to locate a job

Kiran
I do have the same problem ,so let me know if u ll find any solution