Interested to Buy Any Domain ? << Click Here >> for more details...
i have to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.
- 10 Answers
- 15296 Views
- Emirates, IBM, I also Faced
- E-Mail Answers
Answer Posted / vivek ranjan
I Think that you run the queary
select * from tablename where unique_no = 0 and unique_no =
5.
Definitally you featch 1 and 5 record every time when you
execute queary.
| Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
To import the flat file definition into the designer where should the flat file be placed?
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
How we can create indexes after completing the loan process?
what is song in infrmatica...?
Partition, what happens if the specified key range is shorter and longer
How to load data in informatica ?
Explain why we use partitioning the session in informatica?
what is the hint? how to use it to reduce the query processing in program?
Sequence generator, when you move from develoment to production how will you reset
r u done any partitions in ur project?
Explain load alternative records / rows into multiple targets - informatica
What is the difference between STOP and ABORT options in Workflow Monitor?
How to join three sources using joiner? Explain though mapping flow.
What is data caches/ index caches?
What are some examples of informatica etl programs?
