DSXchange

Can we use flat files in Profile stage to analyse the data elements in the falt file? If so, how does it work?

Can anyone tell me how to set up project defaults.
Say I have a database, userid and password how do I set it to default values in the job parameters.
(ie) How do I define them as environment variable and set it to $PROJDEF in Datastage jobs.

Thanks
WNS

As Ken asked - how large is your file? How wide? Sure, you can use CRC32 for this, but what a painful way to accomplish something simple. :? Leverage your operating system. As others have mentioned, check out the sort -u command. Do it 'before job' or (better yet) in the Filter option of the sequen...

By duplicate row, do you mean repeated key but different attributes or do you mean the entire row is a duplicate? If just a repeating key, is the data sorted in the order you like and you need to get either the first or last occurence of the row, or something more tricky? How much data are we talki...

How can we remove duplicates from a sequential file? I know we can load the data to a hashed file and based on the specified key, duplicates will be removed.
Is there anything called CRC32 transform to remove duplicates ?
If so please let me know.

Thanks,
WNS

Hello WaitNSee, does that mean your date logic is that the period requested is the calendar month that is 2 months after the run date? If that is the case then you can specify OCONV(ICONV(OCONV(@DATE,"DM")+2,"DM"),"D2/E") to get the first date of the period and OCONV(I...

Hello Ray,

Can you be more specific on the arguments that I declare inside the routine. In otherwords can you show me a skeleton of the server routine for the above mentioned functionality.

Thanks!

I need to implement a routine to get the period start date and period end date for the given run date. Say if my run date is any date in Jan 2005, the period start date will be March-01-2005 and my period end date will be March-31-2005. So, it will be for every run thereafter. (i.e., if my run date ...

Please let me know what this update statement means.

UPDATE
PSMGR.PS_VZ_STG_ETTP
SET
TLEVEL= :2
WHERE
VZ_LISTINGID= :1

iF you say set TLEVEL = :2 what does it mean?

Hi,

You can change the value of job parameters at run time. Thats the reason they are used for. Compile the job once and run it as many times as you can.
When you hit the run button, the parameter list pops up. Then change the value in that. This works !
Hope this explains your question.

I am looking for answering the interview with a supportive lecture on the same.
Please let me know your views.
thanks!

Can anyone gimme a brief description about exception handling capabilities within datastage parallel extender and what all have you faced so far in your projects and how did you overcome them.
Appreciate your responses. Thanks

can anyone explain me briefly about the performance issues in parallel extenders

You can use the sparse mode in the looku stage to overcome this problem

I have 2 fields which I am passing to the lookup stage as a reference from the Oracle Database. One of the fields of the two which is a key field is generated by the system. I am getting a NULL VALUE FOUND error on that field, which is very unfair. Its a sequence number which is generated by the sys...