How you count the number of records available at your source?
Answer Posted / 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 |
Post New Answer View All Answers
How would you join a node to the already existing domain?
How do you promote a non-reusable transformation to reusable transformation?
Define joiner transformation?
What is aggregator transformation in informatica?
What is meant by a domain?
expain about the tune parameters?
Plz can any one say me how to get the informatica certification materials and dumps
Separate from a database, an information bazaar, and an information stockroom?
What is Cognos script editor?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the databases that informatica can connect to windows?
What are the main features of Oracle 8i with context to datawarehouse?
What are the new features of informatica 9.x in developer level?
What does role playing dimension mean?