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.
Answer Posted / sunny
Simple.Take arithematic calculation, record divisible by five if result is zero then pass it where u want,for first record pass it directly.It's c logic man.i gave one idea that much only.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
can u any challenge your project?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Is there any target staging area in informatica not staging area
What is a pre-defined event and user-defined event?
To import the flat file definition into the designer where should the flat file be placed?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is rank transformation in informatica
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the types of caches in lookup? Explain them.
differences between service based and product based?
How you prepared reports for OLAP?
How might one distinguish in the case of mapping is right or not without associating session?
How do you change a non-reusable transformation to reusable transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What could be the possible resons of locks by user?