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
What is informatica? Why do we need it?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
what is the difference between informatica6.1 and infomatica7.1
Explain joiner transformation in informatica
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is a joiner transformation and why it is an active one?
What is a connected transformation?
How can we update a record in the target table without using update strategy?
Scheduling properties,whats the default (sequential)
How to generate sequence numbers?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is a shortcut and copy in Informatica and how two are different with each other?
How to extract the informatica rejected data?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What will be the approach?