How to load only the first and last record of a flat file into
the target?
- 3 Answers
- 9159 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / harish konda
First connect the exp1 with source and Sequence t/f's.
And next take the sorter and sort the data in descending
order of NEXTVAL port.
And again connect sorter to exp2 and connect sequence t/f to
this exp2.
And then connect this exp2 to router and give these
conditions NEXTVAL=1(of first sequence) and NEXTVAL=2(of
second sequence) then rout to the target.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a surrogate key?
What will be the approach?
what is the size of u r source(like file or table)?
State the limitations where we cannot use joiner in the mapping pipeline?
Explain the tuning lookup transformation - informatica
what is the hint? how to use it to reduce the query processing in program?
Suppose we do not group by on any ports of the aggregator what will be the output?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is a mapplet/worklet in informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Mention few advantages of router transformation over filter transformation.
What do you understand by term role-playing dimension?
What is Data Caches size?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Where is metadata stored?
