DSXchange

We are getting APT_LUTCreateOp warning message in one of our Job Lookup_70: When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the Preserve-partitioning flag on the data set on input port 0. Job design: Lookup stage is having 2 reference Links with the main ...

may be OP is asking about "File Update Mode"(Create/Append/Overwrite)

Thanks Sai,Craig,

Just Substrb instead of substr solved this issue.

Experts, We are extracting data out of the Oracle Enterprise State using "User Defined SQL" Select Substr(Ltrim(Rtrim(NAME)),1,9) as NAME we have defined the Stage metadata column as Varchar length 9 and we are getting the following warning. When checking operator: When binding output inte...

Try this. (@INROWNUM * @NUMPARTITIONS) - @PARTITIONNUM This will generate unique numbers. This will not work correctly. I checked that by a sample design. The below one is the working one.. @PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1 Thought of updating this. It might be useful for some ...

chulett wrote:Nothing, really, pre-8. It's not like you would lose anything by shutting it down. Or are you asking about things you should archive before a permanent shutdown? ...

Hi Chu,
things we should archive before a permanent shutdown.
Thanks in advance

All,

Please share your experiences about the "Procedure to power down" the DS server,(complete switch off) and what is the main information we need to save before power down it. ex: any config files etc..

Thanks in advance.

Search is your friend :) you can do it via oracle procedure too CREATE FUNCTION dbo.LastMonthDay ( @Date datetime ) RETURNS datetime AS BEGIN RETURN (CASE WHEN MONTH(@Date)= 12 THEN DATEADD(day, -1, CAST('01/01/' + STR(YEAR(@Date)+1) AS DateTime)) ELSE DATEADD(day, -1, CAST(STR(MONTH(@Date)+1) + '/0...

Please explain precisely what "I need to pass that date in the job" means. ... :) Hi, I have a file to process that file has a filename as filename_date.csv I need to pass that date in the job is there anyway to do this. If so please let me know. Thanks In Sequential file stage you have &...

Hi All, I have to load data from a file into database. When there are no records in the file(empty file), then i want to enter 1 hardcoded record into table. How can i implement this?Could you pls help. Thanks Have you implemented anything? pls post it here so all can benefit. Btw..What is empty fi...

As of now i think of having a execute command activity stage ( using wc -l filename ) and if output of that execute activity stage is 0 then insert hardcoded value else normal action. I doubt it. The exec command activity will just trigger the output link or it will not(based on the conditional exp...

devesh_ssingh wrote:Hi all,

I got one doubt
.
.
what should output Z will give in case of look-up and join?
and how?

Many many thanks in advance,

Devesh

its based on what are the options u are choosing in Lookup stage and join types...

try writing a routine by passing the arguments like the $APT_ORCHHOME directory plus the dataset to be deleted and use the Dsexecute command in the routine.

Logic? google it... u'll find a lot..
u can do it thru UNIX or via SQL

but,as Chu mentioned, to determine if that day is a holiday the idea is to store the holiday list in a database table and check your input against that.

Raamc wrote:Error was: Unable to open DICT "RT_LOG998"
Regards,
MB

we had this sort of issues earlier...try to check the ID's having right permission and it belongs to appropriate groups..