How to load only the first and last record of a flat file into
the target?
- 3 Answers
- 9207 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 passive transformation?
What is informatica worklet?
Explain sql transformation in script mode examples in informatica
What is the function of aggregator transformation?
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
Have you worked with/created Parameter file
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Does an informatica transformation support only aggregate expressions?
How many ways are there to do 'remove duplicate records in informatica'?
Slowly changing dimensions, types and where will you use them
what are factless facts? And in which scenario will you use such kinds of fact tables.
r u done any partitions in ur project?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is meant by lookup transformation? Explain the types of lookup transformation?
what is index?how it can work in informatica
