DSXchange

Can you post some lines with pseudo-code of what you expect to happen.

-param name=value

You may have to write a routine for that. But what is the controlling factor and where do you intend to store the list of conditions? How do you plan to use them? Will they always use only one column or will multiple column come into picture? You have loads of questions to answer before going down t...

You may have to write a routine for that. But what is the controlling factor and where do you intend to store the list of conditions? How do you plan to use them? Will they always use only one column or will multiple column come into picture? You have loads of questions to answer before going down t...

Your query appears to be more a "reporting tool" nature rather than "ETL".

You can store daily stats in some table and use it to prepare the report.

Even if you write a 'No records' in sequential file, the job will overwrite with a zero-bytes file whilst starting. Thus the work will be lost.

You can try to locate the position of '-' to decide the format.

But how will you know whether '03-04-2009' is 3rd April 2009 or 4th March 2009?

You can try to locate the position of '-' to decide the format.

But how will you know whether '03-04-2009' is 3rd April 2009 or 4th March 2009?

Priyadharshi,

Just a note - if the incoming data has duplicates, then using surrogate key stage may only act as a column generator. The op will then have to split the row for unique and duplicate values.

So it may be better to use stage variables with key change in sort.

Did you modify the hashed file structure after creating ? Is the column you are fetching same as the one you are loading into? Or is the read column a derived on based on source ? Logto DataStage administrator into the prohject and run the command LIST DICT hashedFileName where hashedFileName is you...

Run the data through a sort stage and add 1 in a transformer.

Note - this is the idea for single node run.

For multiple node, you must partition the data by proper key columns and add (partition number * incrementalStageVariable).

Search for partition number to get more information.

Can you copy the job which populates the hashed file and attempt to redirect values into a sequential file to cross-check.

Also what happens if you load 123.45 into universe stage?

What if you set the constraint in the transformer to @FALSE or include a dummy transformer immediately after source and do the same?

Hema,

Not being rude, can you please explain what you tried so far so that others can help from there.

Key is the column which identifies / groups same record. So use the technique to find which column must be key.

If you login to Admin again, can you see the Project ?

What is the location where you have created ?