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
What are the static cache and dynamic cache in informatica?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What you know about transaction control transformation?
tell me the rules and responsblites in our project(my project is development)
Can we change Dynamic to Static or Persistent cache? If so what happens?
my source is junk data how will u remove that junk data by using unix please any one replay me
What are pre and post-session shell commands?
What are mapplets?
How do you migrate data from one environment to another?
What are the tuning techniques you applied during your last project
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Performance tuning( what you did in performance tuning)
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain direct and indirect flat file loading (source file type) - informatica
How do you take back up of repository?