DSXchange

Could anybody please reply on it

I have read one post in Dsxchange long ago where if we gave input dsx file as input through macro in excel.Then it will show all jobs and their path in excel.I did not remember that link.i tried in search option but no luck.Could anybody provide link for it

I need to select one record out of 2 records.any record is fine.similary for rest of the records also.Nit sure how to proceed and anybody help on this

chennai,hyderabad,500
hyderabad,chennai,500

I have data as mentioned below.source is sequential file source,destination,distance chennai,hyderabad,500 hyderabad,chennai,500 chennai,bangalore,600 bangalore,chennai,600 chennai,bangalore,600 I have to select 1 record out of 2 records.ay record is fine. chennai,hyderabad,500 hyderabad,chennai,500...

In user variable activity following derivation is defined Field( Trim (EReplace(Get_Extract_DTTM_Param.$CommandOutput,@FM,""), ("":'"':"") , "A") ,"|",2). Can anybody explain what trim will do in above case.basically i did not understand below p...

It was not a Interview question.

I have two tables table1 and table2.Lookup stage is used between table1 and table2.table1 is master link.In lookup stage we have following properties Condition is table2.Col2='ABC',condition not met=Continue and Lookup failure=Drop. I want to convert above logic to sql.Any body help on this.I know h...

Kindly let me know whether my undersanding is correct or not?

I believe following settings are sufficient to handle my scenario after reading the documentation and please correct me if i am wrong? Fail on error=YES if you specify Fail on error as Yes, all statements are executed as one transaction. If one fails, the statements already executed rolls back and t...

I have one parameter set with different value files ex-P1 is parameter set and dev1,tst1,prod1 are value files for P1 select col1,col2 from #P1.tablename# I have to replace #P1.tablename# with corresponding value from value file it may by dev1,tst1,prod1.we are calling above sql statment using NZ co...

I am new to netezza and i have one sql file consists of following statements which we are calling from NZ connector[Read from sql option] Insert statement1 Update statement1 Updatestatement2 I want all 3 sql statments should be success and if any sql statement is failed i want to rollback all the sq...

anybody help on my clarifications?

Thanks all for input and just want to know my understanding correct or not. 1)cat temp.txt 1,2 3,4 In notepad++ i can see above file as 1,2CRLF 3,4CRLF As per ArndW,datastage will replace @FM[CRLF] with '' when i use Ereplace(Cmd_CheckRejectSize.$CommandOutput,@FM,'').Is my understanding is correct?...

1)There are no message handlers defined at project level or joblevel

2)How to check Jobmoniter at back end and when I start Job Monitor in director when job is running,i can see the statisces

It was set to false and i make it true but no luck.the Job does not have any warnings