how can we load first and last record from a flat file
source to target?
Answer Posted / hina
Below transformation would work: Add the Nextval port of the sequence generator to both the Rank Transformations. In rank transformation select Top and Bottom resp.
------ Rank Transformation (Top)----Tgt(Ins1)
|
SQ---Sequence Generator-----
|
-------Rank Transformation(Bottom)-Tgt(Ins2)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain sql transformation in script mode examples in informatica
Where do we use mapping variables in informatica?
What are the different ways to implement parallel processing in informatica?
How to Create a folder using pmrep command?
whats the logic to load the lower level of granularity of data to fact table.
What are the modules in Power Center
What does update strategy mean, and what are the different option of it?
What is the need for an etl tool?
What is the different lookup cache(s)?
What are the types of presistent cache in look up tr.
define galaxy repository in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is data caches/ index caches?
tell me 5 session failure in real time how can you solve that in your project?