DSXchange

consider we have one job in which 10 source stages(including hashfiles,sequential files and database) and in other job i have 15 source stages(including hashfiles,sequential files and database) , problem is that in second job if we use hash file as intermediate stage then how can we decide this is o...

You are right that we can do with this function , in my case i want output for all jobs in a project, but i dont want to explicitly specify stage name multiple times, with differnt jobs, stage name may be different. I want generic output for same. [quote="rachitha"][quote="shaikf"...

Yes, i have seperate links for insert and update. and where can i actually find required information from Kduke's site, there are lots of things available in his site. can you please guide me for same ? [quote="loveojha2"]Do a Search on ETLStats. Bunch of goodies. [quote]3) How many loaded...

With Row generator also data is getting truncated. you are right and we think that we have to raise this issue to IBM. [quote="ArndW"]Can you distill this problem into a simple job with a row generator with just one column defined as CHAR(7) and with generated value of "profile" ...

No, getting value in output : "profile:Space(1)", but here if i use varchar(8) then getting "profil" as output.

ArndW wrote:Umm, now I am confused. If you declare this column as CHAR(8) and assign it the value "profile " it gets truncated to "profil "?

Despite , data is getting truncated in output, only last character

ArndW wrote:In the output stage change your CHAR(7) to CHAR(8) and run the job. Is the data still truncated or does it work (or do you get another error message)?

Have seen in DS Admin with project wise, NLS tab is not Enabled. can u pls more clerify on "If you add that one character to the PX job definitions does it work? " This is certainly an odd problem. If you add that one character to the PX job definitions does it work? Also, do you have NLS ...

7 th character is some garbage(Junk) value.It is not space or any other specified value.In log file datastage doesnt throw any warning or err msg. while writing to sequential file datastage does not give any warning or error in log file and i did not get any truncation on data A Char(7) field cannot...

i have fields and its output : Field Name Datatype I/p value O/P value O/p Datatype a varchar(4) 'pp' 'p' Varchar(4) b varchar(3) 'ppp' 'pp' Varchar(3) c char(7) 'profile' 'profil ' char(7) Could you tell us what the column definitions are and what length the truncations are occuring at (i.e. VarCha...

While loading Sql Server table through datastage, data is getting truncated in char and varchar data types' fields(Last character of every field), In table i have some numeric fields and not getting any data truncation there. Have created PX job for same as i am using Odbc or DyRdbms stage and getti...

Hello, I understood that with char(10) we cant give '', we have to provide equal length output for same. Hence i changed my condition to "If Summary_Report_ToTfm.Date < Summary_Report_ToTfm.Start_Date Then Summary_Report_ToTfm.Date Else Summary_Report_ToTfm.Start_Date" , still i am getting...

My Formula for start_date column is "If IsNotNull(Summary_Report_ToTfm.Date) Then (If Summary_Report_ToTfm.Date <> '' Then Summary_Report_ToTfm.Date Else Summary_Report_ToTfm.Start_Date) Else Summary_Report_ToTfm.Start_Date " Date is coming from Lkp database and it is not NULL field in tab...

what is USS System and full form of USS ? What are performance issues if we install datastage(Enterprise edition) on USS system rather than unix system ? diffrentiate between USS and Unix ?
Please share your ideas on this topic.

Regards
Hiten

Hi,
Pl refer viewtopic.php?t=100893 link , this will through u some lights on your issue.

You can write after job subroutine with the help of functions like DSGetLogSummary and DSGetLogSummary,this may useful for what u want to capture. Hi, after the completing the job execution i need to store the howmany records are processed and howmany records are regected into database. is there any...