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)?
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 |
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
Can we combine a flatfile and a database table using an UNION transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is a stored procedure transformation?
Why filter transformation is an active one?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
Target increases every day even though no new record was inserted
Write the different tools in the workflow manager?
If I have a index defined on target table and if set it to bulk load will it work ?