DSXchange

they are same like 1.7 million

shivan

pnchowdary wrote:Hi Shivan,

Could you tell me how many rows you see on the link that goes into the transformer and how many rows you see on the link that goes out of the transformer?

mapping is like:
some columns, if data is "y" , do this else do this.
others are one to one

thanks
shivan

pnchowdary wrote:Hi Shivan,

After extracting data from SQL server and before loading into DB2, what tranformations are you applying to the data?

what i doing is that. i wrote a sql query to extract data from sql server. then i m loading in db2. The sql query extracts 1.7 million rows. But in db2 only 40,000. There is one to one mapping. thanks shivan Hi Shivan, What exactly do you mean by "but i m just using grouping". Could you pl...

i am loading the data from sql server to mainframe. shivan but i m just using grouping. How can it only process 40000 out of 1.7 million. thanks shivan Hi Shivan, 1) Check how many rows you are extracting from source( SQL server) 2) At each stage where you have a constraint, store the reject records...

but i m just using grouping. How can it only process 40000 out of 1.7 million. thanks shivan Hi Shivan, 1) Check how many rows you are extracting from source( SQL server) 2) At each stage where you have a constraint, store the reject records in a reject file 3) Then finally, No of rows you are tryin...

I am running a job. The job suppose to load 1.7 million rows in the mainframe table. It runs successfully but in the actual mainframe table it only has 40000 rows. We are doings some grouping. But i dont think so grouping reduce the data to that extent. Data is loading from sql server to mainframe. ...

hi,
i m new to datastage. i was going through the documentation but couldnt find what is the real use of hash files. The only thing i understand is that it uses hashing algorithm to feed the rows.

shivan

hi, the way it is working is like this: I have a update timestamp column. So if there is an update, then it will overwrite the update timestamp column with a current date. My question is that, whether i m doing this right or not. Because i m going against only the update and new columns which may be...

hi, I have a job which runs everyday. There are like 60,000 records, so it takes like 15 mins to run. This job has to run everyday. I am thinking if i add a condition to the job like update=update(date,-1) so that it will fetch only those records which are updated and inserted yesterday. So that it ...

i still have the same problem. The query i wrote is this:
SELECT COUNT(*) FROM (SELECT a.lf_id,COUNT(*) FROM escalation a GROUP BY a.lf_id)

thanks
shivan

Sainath.Srinivasan wrote:Give an alias from the sub-table.

so can i leave it blank. What its purpose then.

thanks
shivan

Sainath.Srinivasan wrote:No

hi, i have a sql query which i defined in the source file and i am taking the data through that query. Where as i also defined the column names in the column section of the source file. Beside the column name there is a derivation column. I am just confused what i have to write there. For eg: there ...

the second statement doesnt run in sql server. I m trying to run the query i get the error: Line 1: Incorrect syntax near ')' thanks shivan Try these queries against the database. SELECT COUNT(*) FROM tablename; SELECT COUNT(*) FROM (SELECT A,COUNT(*) FROM tablename GROUP BY A); What do these tell y...

hi,
how i can reset the job for more info.

thanks
shivan

Sainath.Srinivasan wrote:Abnormal termination can be due to several reasons and memory problem is one of it.

Try resetting the job for more info.

hi,
i m getting this error when i run the job. I think it is due to lack of memory or the server is very slow because the job runs ok in the evening. But while running at day time. It gives this error.
As i am new to datastage. I want to confirm that that i m correct or not

thanks
shivan