how can we load starting with 11th record of a table from
source to target
Answer Posted / ajit
use sequence generator with port key to source rows and then
use filter condition key>11
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are roles and groups and benefits of using them?
Explain the types of transformations?
How to join three sources using joiner? Explain though mapping flow.
What is the scenario which compels informatica server to reject files?
tell me about your project functionality
What is option by which we can run all the sessions in a batch simultaneously?
Define sessions in informatica etl?
What is meant by incremental aggregation?
Define mapplet?
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
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How might you approve all mappings in the archive all the while?
What are the various types of transformation?
Name the different lookup cache(s)?
What is the Process to creating lookup transformation in informatica