how to load only the first and last record of a flat file
into the target?
Answer Posted / etl guru
not possible first & last function in aggregator
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Differentiate between router and filter transformation?
In which transformation you cannot drag ports into it?
Reusable transformation and shortcut differences
How are indexes created after completing the load process?
Write the program through which the records can be updated?
Design time, run time. If you don't create parameter what will happen
what is mean by complex business rule ?
What are the types of lookup transformation?
Explain the difference between mapping parameter and mapping variable?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the tasks that source qualifier perform?
What is standalone command task?
How many number of sessions can one group in batches?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
can u any challenge your project?