How you count the number of records available at your source?
- 3 Answers
- 13497 Views
- Zensar, I also Faced
- E-Mail Answers
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
Explain incremental aggregation in informatica
What is the fact table?
Mention few advantages of router transformation over filter transformation.
What is the advantage of informatica?
In which transformation you cannot drag ports into it?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain the types of transformations?
How big was your fact table
What are the differences between joiner transformation and source qualifier transformation?
What is an unconnected transformation?
How to create or import flat file definition in to the warehouse designer?
Under what condition selecting sorted input in aggregator may fail the session?
How an expression transformation differs from aggregator transformation?
What is dynamic cache?
