DSXchange

Hi Ray,

Thanks for the reply.

Log is not providing any warnings/information regarding Delete statement.

---------------------------
Thanks,
Phani

Hi Experts, I am using Delete statement in Before SQL option to delete few records and write mode=insert in Oracle connector stage. Job completed successfully. But Only it inserting the records. Deletions are not taking place. 1)Why did it fail to delete records? 2)Any alternate methods to delete so...

Hi,

Try with Trim(),Upcase() and Field() functions.

----------------------------
Phani

Thanks Ray.

If we took write mode=Delete, Log shows Delete count also.

Suppose My Before SQL is: Delete from <Table_Name>

Log is not showing Delete records count. How can I get the deleted record count in this case?

---------------------------------------
Thanks,
Phani

Hi Experts,

Can we get the event info of Before SQL Statement in Log?

----------------------
Thanks,
Phani

Hi Experts, I am facing a performance issue. In my Job the Source is Sequential file and Target is Oracle Connector. The job has 2 Lookups and 2 Transformers in the Job design. In QA:Job fetches records from source sequential file in 450 rows/sec In Production:The same Job fetches records from sourc...

Hi Experts,

I am generating sequence numbers by Transformer's Surrogate Key Option.Initial value is 1.

My requirement is:
Once the Surrogate key value reached to 1000,Then it has to start from Initial value.

Thanks in advance,
Phani

Yes ..I am agree with your answer .. If the "seed" value is same for mutiple runs..it will produce same random numbers. That's why in our job, we are passing "seed" from job Sequence by using KeyMgtGetNextValue() function. For every run it will generate new sequence number. seed_...

Your randomly generated numbers in the Row Generator stage will not be unique and the KeyMgtGetNextValue won't work either. ... Row genarate stage, which is producing unique random numbers based Random algorthm (Type=random) we are passing Limit and Seed values as parameters... If I provide the see...

Row genarate stage, which is producing unique random numbers based Random algorthm (Type=random) we are passing Limit and Seed values as parameters... If I provide the seed value is unique number for every run and getting unique random numbers.. seed_Val_ABC-->KeyMgtGetNextValue(1) seed_Val_ABC-->Ke...

Every run will generate unique random numbers. For every run we are genarating 1000 random numbers for ABC and 500 random numbers for XYZ Job design : RowgenStage(ABC): Feilds: Cust_Name(varchar) RanNum(Integer) --> Type=random Limit=1000000 Seedval=#seed_Val_ABC# RowgenStage(XYZ): Cust_Name(varchar...

Requirement is : we need to generate unique random numbers for two customers. (ABC,XYZ). Input Cust_Name UpperLimit ABC 1000000 XYZ 300000 Target1 Cust_Name RandomNum ABC 100 ABC 463487 ABC 6579 ABC 87456 6709 Target2 Cust_Name RandomNum XYZ 3480 XYZ 23090 XYZ 54 XYZ 90045 XYZ 546

Hi,

How to generate unique random numbers for each run of a sequence?

Thanks,
Phani

Hi,

The combination of Col1,Col4 is not working for updates.
Any suggestions to sort out this issue?

Thanks,
Phani

Thanks Ray. Table has no Primary keys.Col1 and Col4 are not null columns. I am doing upserts based on Col1,Col4. Example: Table contains Col1 values 1,2,3,4... and Col4 is Hardcoded with 'A' Requirement is: i need to add new records which have Col1 values 1,2,3,4... Col4 is Hardcoded with 'B' all ne...