reading file validations and log file
Posted: Sun Jun 01, 2008 9:27 am
i get a CSV file i am reading it and inserting/updating a table based on conditions
I need to get the values of how many rows are in the file: Is there any function that does this
how can i know which row number from the file is being processed ...so that if that row fails i can insert into log file that this rownumber failed to load
i need to know how many rows were inserted into the table as well ... is there nyother way than using sql to do a count(*) from the table and get the number of rows inserted ....
file -- > tranformer -- link1 --> odbc stage1 (insert table)
-- link 2 --> odbc stage2 (update table)
is there any function/macro that will tell me how many rows were sent over from transformer to link1
I'm tryin to get my 1st datastage ETL map done any help would be appreciated
I need to get the values of how many rows are in the file: Is there any function that does this
how can i know which row number from the file is being processed ...so that if that row fails i can insert into log file that this rownumber failed to load
i need to know how many rows were inserted into the table as well ... is there nyother way than using sql to do a count(*) from the table and get the number of rows inserted ....
file -- > tranformer -- link1 --> odbc stage1 (insert table)
-- link 2 --> odbc stage2 (update table)
is there any function/macro that will tell me how many rows were sent over from transformer to link1
I'm tryin to get my 1st datastage ETL map done any help would be appreciated