DSXchange

It would help were you to obtain a premium membership so as to be able to see the totality of Craig's and my replies. Hi , Well i dont have any idea of viewing the replies only if we are premium members only.i was wondering why i couldnt able to view the full message.anyway i will see that i can ta...

Hi , So i have my target database and connecting to hash file and doing lookup .so now if the record is repeated more than three or four times having the same business ky , then hash file will take in the order what is ther in the target database.so what if the last record in the target might be a r...

Only populate the hashed file with "current" records i.e. ones where your current indicator = 'Y', something I thought you said you were already doing. :? hi craig, Then we get only one record which is set as current indicator as 'Y' and one record which is set as current indicator as 'N'...

Hi everyone , when i use hash file and do a lookup , everything is working fine .But here if i use my key as a business key , then if the keys are repeated , hash file is going to pick any one record with the same key.so how do i do lookup based on the hash file as i might get a chance of hash file ...

Hi ,

My DBA havent monitored .So do i need to contact my DBA regarding this issue.

thanks in advance

Hi everyone,

when i try to create a copy of job and change some stages and run the job, it hangs up.when i try to run the original job by which i made a copy ,it is also hanging up.can any one tell me what might be the issue with this?

Hi everyone,

when i tried to rebuild the same job again reducing some stages and used outputs as sequential files it is working but when i tried to use database as output its not working, i mean its in running state.can any one tell what might be the issue.

thanks in advance

Hi ,

i tried to make a copy of it and used output as a sequential files and also reduced my transformations and stages but still facing the same problem.Well it did work me 2 days back but today i tried to execute the same job its in running state only.

thanks in advance

Hi everyone, I performed a job with some transformations and some stages.when i compile and run the job ,its in running state showing all yellow and blue lines.It is in the running state only not getting the result, so finally i aborted and ran the job again but still the same process i.e. in runnin...

Hi everyone, first of all i would like to thanks everyone for your valuable suggestions.first i did lookup with direct database it didnt work for me.but when i Pre-load a hashed file with the CURRENT records from the target , it is working fine.now its resolved.But can you guys expplain me as to why...

Hi ,

i am doing look up based on the business keys and and using the same surrogate key for the updates and inserting new surrogate key for the inserts.

thanks in advance

Hi , my source and the target is a database. i am trying to implement scd type2 .so i have given a seperate links for inserts and updates.first time when i load the data inserts and updates are working fine.when i load the data for second time , tha records which are new are inserting but the record...

Hi craig, thanks for your valuable suggestions .it is working fine but i am having a doubt what if we are loading millions of records every time .does the KeyMgtGetNextValue('target table name') provides a unique value every time we load.And when i am loading for the first time every thing is workin...

hi , when i use KeyMgtGetNextValue(linknamei.e. surrogateid) .i got this error DataStage Job 38 Phantom 5556 Program "DSX.KEYMGTGETNEXTVALUE": Line 69, Improper data type. Attempting to Cleanup after ABORT raised in stage CopyOfscd2with_SK..xfm1 DataStage Phantom Aborting with @ABORT.CODE ...

You use KeyMgtGetNextValue('X') and for every discrete value of 'X' it will track an incremented surrogate value. We used the target table name for 'X', including owner if needed to make it uni ... hi , So you mean to say X value should be target.Surrogateid i.e. target.linkname. but itried in that...