how can we load first and last record from a flat file
source to target?
Answer Posted / srinu
Hi,,, Vinod, As per your Solution we have to check
complete data Table for ,,
syntax for 1st,last:::
FIRST( ITEM_NAME, ITEM_PRICE > 40 )
FLOOR( PRICE )
ok,,,
Any corrections Let me Know,,,
srinu.srinuvas@gmail.com
Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the tasks that can be performed using sq?
What is a router transformation?
Why sorter is an active transformation?
Explain the use of aggregator cache file?
Repository user profiles
How we can create indexes after completing the load process?
How do you use reject loader.
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 kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the different types of repositories created using informatica?
What are mapplets?
What is target load order?
Enlist the tasks for which source qualifier transformation is used.
What are active and passive transformations?