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

Question Posted / manojdubba

3 Answers
14316 Views
Zensar, I also Faced
E-Mail Answers

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

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

0 Answers Infotech,

What are the main features of Oracle 8i with context to datawarehouse?

0 Answers

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers TCS,

Explain scd type 3 through mapping.

0 Answers

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers Cognizant,

What is the use of source qualifier?

0 Answers

How can we get multiple output values using an unconnected lookup transformation?

2 Answers TCS,

which transformation uses cache?

3 Answers Keane India Ltd,

How to delete duplicate row using informatica?

0 Answers

what transformations are used for Variable port?

2 Answers

For more Informatica Interview Questions Click Here