How you count the number of records available at your source?

Answers were Sorted based on User's Feedback



How you count the number of records available at your source?..

Answer / venkat

Use aggregator transformation for getting number of record
count from source.

Is This Answer Correct ?    7 Yes 0 No

How you count the number of records available at your source?..

Answer / nagaraju

count(*) from table;

Is This Answer Correct ?    5 Yes 0 No

How you count the number of records available at your source?..

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

Post New Answer

More Informatica Interview Questions

How do you take care of security using a repository manager

2 Answers  


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.

4 Answers   TCS,


what is the size of ur database(like oracle)

2 Answers   HP,


What are events in workflow manager?

1 Answers   Accenture, IBM,


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 ??

1 Answers   IBM,






What is an active transformation?

0 Answers   Informatica,


how to delete duplicate records by using filter transfermation?

3 Answers  


What are the features of complex mapping?

0 Answers  


what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,


Different circumstance which drives informatica server to expel records?

0 Answers  


how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,


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?

7 Answers   Polaris,


Categories