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
- 15578 Views
- Emirates, IBM, I also Faced
- E-Mail Answers
Answer Posted / vinay
Here are the steps that you will need to follow to catch record numbers 1,5,11,15,21,25,31,35.....so on.
Step1: Create an expression T/F and define a variable to count the number of records, say we name it as "CNT"
CNT (int) = CNT+1
Step2: In the same T/F, at the end of all the ports define a flag, say we name it as
flg_VALID_ROW (string(1))=
IIF((SUBSTR(TO_CHAR(CNT),-1)= '1' or
(SUBSTR(TO_CHAR(CNT),-1)= '5'),'Y','N')
Step3: Next define a Filter T/F, where you can catch hold of the record using flag = 'Y'
Filter Cond'n: flg_VALID_ROW = 'Y'
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is rank transform?
Difference between Data and Index Caches?
What is Data Caches size?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How can you generate reports in informatica?
What are mapplets?
Write the prerequisite tasks to achieve the session partition?
Explain lookup transformation is active in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How do you change a non-reusable transformation to reusable transformation?
Explain the features of connected and unconnected lookup.
How does a rank transform differ from aggregator transform functions max and min?
What differs when we choose the sorted input for aggregator transformation?
Partition, what happens if the specified key range is shorter and longer
