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)?
- 1 Answers
- 6143 Views
- iNautix, I also Faced
- E-Mail Answers
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 |
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
On which transformations you created partitions in your project?
how to obtain performance data for individual transformations.
What are the tasks that Loadmanger process will do?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How many ways are there to do 'remove duplicate records in informatica'?
What is CDC? How to implement CDC?
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
Roles and Responsibilties of Informatica Production Support Member?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
Teradata 
