I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
Answer Posted / ashok
Sequence Generator
Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How can one identify whether mapping is correct or not without connecting session?
How identifying bottlenecks in various components of informatica and resolving them?
What are the different types of olap? Give an example?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
complex mapping ur project u r invlve can u explain and give real time example give me ?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What do you mean by enterprise data warehousing?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Is there any way to read the ms excel datas directly into informatica?
What are the performance considerations when working with aggregator transformation?
waht type of interface is used for testing the data in informatica
Mention few advantages of router transformation over filter transformation.