how can we load first and last record from a flat file
source to target?
Answer Posted / dharmendra
SRC QF -> SEQ -> EXP -> AGR -> RTR -> TGT
create a port in expression t/r and generate a value for
each row using SEQ genrator, then in Agr take count of all
th record.create 2 condition in in router one with SEQ = 1
and another with SEQ = count of rows (this will give last
row).connect both to target.dont forget to give reset
option in SEQ generator.
Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
How to load the data from people soft hrm to people soft erm using informatica?
Is it possible to create multiple domains on a single Informatica server?
What is a pre-defined event and user-defined event?
What is the cumulative sum and moving sum?
How can informatica be used for an organization?
What is an Integration service in Informatica?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
how to load dimension table and fact table. plz tell me the steps.
What is aggregate cache in aggregator transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are connected or unconnected transformations?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
In how many ways we can create ports?
How to join three sources using joiner?