DSXchange

ray.wurlod wrote:Yes, and so can the manual (pivot.pdf). ...

yeah !! thx

Can anyone give me example how pivot stage works...

nani0907 wrote:What are the feild defaults and final delimetrs option given in that satge?

hey problem solve no worry !!!
view data period was set to 11 i have make it as 1

No, they're not or you'd be seeing all records. You have a metadata mismatch and the "bad" records are being rejected by the stage. Try all Varchar fields and see if that helps. ... Problem got solve actually the view data period was set to 11 now i have changed it to 1 now i am able to s...

When you click on View data in the Sequential file, you will get a "Data Browser" Pop up. Make sure the "Rows to Display" is not 1 and 10 (since your record count is 10). If it is set to 1, you will always see 1 record irrespective of Record Count in the sequential file. If you ...

nani0907 wrote:the problem may be that you might have not defined the coulms corectly and also check the first line is column name as true if you have header record for your file

Actually i have defined all the column names correctly and the condition for firt line should column name is true.

Sequential file has 10 records.Delimeter is comma separated.
when i was trying to view it via job,It is showing me only one record instead of 10 while in unix i can able to see all the records.

Please solve this !!

Source-- file having dulicate records
Target--Need only unique records

Conditon--Need to remove dulicate records and paas the unique records and reject the dulicate records into reject link.


Please help me out with this scenario.

Thx,
Mayura

Hi, Please let me know the command to view the routine in datastage admin command line. thanks, Datastagepx 8) Why? The routine source code is stored in a database tab ... hey routines are not stored in database.It is datastage.. and need command to view routines by login to datastage admin and sel...

Hi,
Please let me know the command to view the routine in datastage admin command line.

thanks,
Datastagepx