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
6782 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 parallel querying and what r hints.

1 Answers

In a sequential batch can you run the session if previous session fails?

4 Answers

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers TCS,

What is the target load order?

3 Answers HCL, Informatica,

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers IBM,

Can you copy the session to a different folder or repository?

1 Answers

Explain about Recovering sessions?

1 Answers

what is the exact meaning of domain?

3 Answers

sorce is a flatfile only 1st and last row should insert to target how will u do?