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 |
How do you take care of security using a repository manager
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
what is the size of ur database(like oracle)
What are events in workflow manager?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
What is an active transformation?
how to delete duplicate records by using filter transfermation?
What are the features of complex mapping?
what is the main advantage of unconnected lookup
Different circumstance which drives informatica server to expel records?
how to design mapping half of source table records into one target and remaining half into another target
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?