In Flat file, I need Header, Footer and No of rows in Last column. How will u ac

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

Question Posted / jeyakumar.uv

1 Answers
6710 Views
iNautix, I also Faced
E-Mail Answers

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Lev..

Answer / joe

s...rank1 (for header)-top option..........Target1
.
.....Aggregator (Count(lastcolumn))........Target2
.
....rank2(for footer)-bottom option........Target3

Is This Answer Correct ?

0 Yes

5 No

Post New Answer

More Informatica Interview Questions

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers Accenture,

How is Data Models Used in Practice?

1 Answers

what is meant by data driven.. in which scenario we use that..?

2 Answers IBM,

explain about lookup t/r?

1 Answers IBM,

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers Wipro,

If the records doesnt satisfy the filter condition where will it go?

10 Answers IBM,

select count(1) from emp? what is the o/p?

5 Answers TCS,

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers Flextronics,

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers

how much memory (size) occupied by a session at runtime

4 Answers Wipro,

What is informatica?

0 Answers

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers FCS, IBM, Satyam, TCS,

For more Informatica Interview Questions Click Here