DSXchange

Hi Friends,


I have issue on scheduling.

Today i scheduled the job due to the network connection job will be aborted but next day same time it run automatically? there is any option is there for automatic reschedule the job.

If any thing please let me know.

HI Friends,


In copy stage Properties FORCE=TRUE/FALSE.

True to specify that DataStage should not try to optimize the job by removing the Copy operation.

What is the meaning of OPTIMIZE THE JOB. I am unable to understand this.
Please let me know..

Hi,


filter option work in windows? i tried windows environment but job will aborted.

Hi,

yes i faced same problem. but i solved with what explained by sura i got correct answer. u can also try that one.

*.txt

Hi friends, I am facing with compare stage. i have two sequential files with same fields and also same rows but iam facing below fetal error. main_program: Fatal Error: Attempt to drop schema variable: "first.rec"; this may be due to dropping a subrec which contains a schema variable; this...

Hi friends, this is will work by vertical pivoting. |--------------------------------------filter | | | | | | | | | | src------------->copy---------->removedupli------>lookup-----------trg 1. in copy stage take two o/ps 2.in remove duplicat based on key 3. in filter take 4 conditions sal= deptno10 s...

Hi marchana,
u can do this by using substring function in transformer
substring(colname,[1|1])=col1
substring(colname,[4|1])=col2
substring(colname,[7|1])=col3

after that u can take one pivot stage in o/p give col derivation col1,col2,col3

hi, first tel me which one is master? and if seq file is master how can u get these fields(account, Collatral, markt_val amt,PORTF_NM) in reject

for this source is how many cols?

ok please can u explain with example?

how will work soundex() in transformer?

how does padstring() works in transformer?

which key i want to hash partition.

if it run in 2node or 4node how will get top 5 sums

Hi Friends,

i have two files
f1 have cust_id,Tran_id,sales_amount

f2 have cust_id,cust_name

i want o/p like cust_name, Total_sales_amount

I want only top 5 Total_sales_amount customers.


how can do this?