If a table contains 100 records we have to fetch 50-100
records from source to target?how
Answer Posted / nitin
Use a sequence generator Transformation to filter the
records from 50 to 100 and then load to Target.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the components of Informatica? And what is the purpose of each?
Clarify the utilization of aggregator cache record?
What is an active transformation?
What is substr in informatica?
How many transformations can be used in mapplets.
What is expression transformation?
What is dynamic cache?
What could be the possible resons of locks by user?
Explain the difference between a data warehouse and a data mart?
What are the new features of Power Center 5.0?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is the procedure for creating independent data marts from informatica 7.1?
How to update or delete the rows in a target, which do not have key fields?
How do you use reject loader.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?