DSXchange

Folks, I am stepped in to do production support, and found a the job with constraint Not(Lookuplink.NotFound) Where lookuplink is link from hash file used to do lookup, my question is .Notfound [/size] is built in function or routene or transform, i never got a chance to work on this kind one before...

Thanks I got till filtering six records with your suggestion, but now coming to pivot stage, I never used and When i was going through help it says use derivation Say for example now i have Regionkey clientid Plancode 2 1963 5af 2 1963 4ac 2 1963 5ab 2 1963 5bc 2 1963 4bd 2 1963 4df 2 1962 5ab 2 196...

Actually it was the reverse case, we develpoed the wharehouse and need populate data from here to SalesForce.com using vitria, for this I had develpoed a function and stored proceadure to populate data from wharehouse to Vitrai Tables and its taking 48 minutes to populate about 2000 records, since w...

I have source as Code: Regionkey clientid plancode 2 1962 5ab 2 1962 5bc 2 1962 4ac 2 1963 5af 2 1963 4ac 2 1963 5ab 2 1963 5bc 2 1963 4bd 2 1963 5fg 2 1963 4df regoinkey is same for all, some clients have more than 6 plan codes, some clients have less the 6 plancodes, when a client have more 6 plan...

Folks, after doing lot of reasearch I had found the there were three records which were causing the proble to load them they were 0101/01/01, 0102/01/01, 0102/01/02, fo rhtis i had implimentd dirty solution which works that is I defiend two stage variable first variable = DateTimeStampToInternal(sou...

In the generated output at odbc i could not find any to-date conversion And coming to the routene before it was A = Iconv(Arg1[1,10], "DMDY") Ans = OCONV(A, "DMDY") i changed to A = Iconv(Arg1[1,10], "DMDY") Ans = OCONV(A, "DYMD") Now i encounter different typ...

CSRFQ..X_RFQ.Out_RFQ_INSERT: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO STG_RFQ(SaleProbability, DateProposedEffective, SalesDeadLineDate, EligibleEmployees, CloseType, MemberCount, UserID, ClientID, BrokerID, CloseReason, RFQID, IsLifeQuote, IsDentalQuote, status_ind, RegionKe...

YES i MADE THAT OBSERVATION AND LATER CORRECTED IT BUR IT STILL DOESN'T WORK

It doesnot work

SELECT TO_CHAR(AU_LEAD.POTENTIAL_DATE, 'YYYY-MM-DD HH24:MI:SS'), (AU_LEAD.ACS_CONTR_EFF_DATE, 'YYYY-MM-DD HH24:MI:SS' are the two dates being retrieved from source through oraoc I have not defined To_char, but Ora is automatically taking it, but my problem i need to only pass effective datec > 12-31...

WELL KC IF THAT CASE AT OTHER PLACES WHERE I AM JUST PASSING THE DATA ITS GOING THROUGH, EVEN IN THE SAME JOB THERE ARE TWO DATE FIELDS AND IF I KEEP BOTH DATE FIELD ONLY 77,228 RECORDS ARE PASSING AND THE ERROR I SAID ABOVE IS HAPPENING, IF KEEP FIELD 1 ONLY(EFF DATE) THEN ALL 94,000 RECORDS ARE PA...

Hi folks My source oracle 7 and target SQL, when I run a job it trows me an error after running 77,000 record which is fatal error type there are two date fields but if the problem is with date time, it should abort first only, its aborting after running 77000, and date fields are yyyy-mm-dd hh:mm:s...

I got the knowledge, really i solved the problem using the sql since its from same stage but i waqnt to have some knowledge, i got the tip and i will go find out from help how to use merge stage for the future usage

thanks thanks thanks :D

Well i am sorry for not being precise in my first post

is there any way to do that kind of join in datastage betwen two table having multiple primary keys

Well i am sorry for not being precise in my first post

is there any way to do that kind of join in datastage betwen two table having multiple primary keys