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
- 15300 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 xml source qualifier transformation in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Mention some types of transformation?
How are indexes created after completing the load process?
Which transformation is needed while using the Cobol sources as source definitions?
Write the program through which the records can be updated?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Whats there in global repository
What is standalone command task?
Reusable transformation and shortcut differences
Explain informatica architecture - version 8 / 9
What is the reusable transformation?
What is the use of an aggregator cache file?
Differentiate between sessions and batches?
Write the unconnected lookup syntax?
