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
- 15364 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
What are junk dimensions?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How can we update a record in the target table without using update strategy?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How to extract the informatica rejected data?
Explain the scenario which compels informatica server to reject files?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
To import the flat file definition into the designer where should the flat file be placed?
What are the differences between a connected lookup and unconnected lookup?
State the differences between sql override and lookup override?
write a query to retrieve the latest records from the table sorted by version(scd)
Explain the informatica workflow?
What is a joiner transformation?
can we override a native sql query within informatica? Where do we do it?
