How you count the number of records available at your source?
Answers were Sorted based on User's Feedback
Answer / saritha
craete a dummy table create table abc(source_name varchar2
(10),count number);
write a sp create or replace prod name
select count(*) into v1 from table name
insert into abc ( 'dvhadvav',v1);
commit;
end
import that sp in the maping and slecte the pro as sorce
pre load.
| Is This Answer Correct ? | 1 Yes | 2 No |
Informatica and datawarehousing courses in Pune?
How to elaborate tracing level?
What are the restrictions of union transformation?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
what is unique constraint error ?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
Separate from a database, an information bazaar, and an information stockroom?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
What are the reusable transforamtions?
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties