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
- 15365 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 a difference between complete, stop and abort?
How you can differentiate between connected lookup and unconnected lookup?
How do you load first and last records into target table?
Explain informatica architecture - version 8 / 9
Name the different lookup cache(s)?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain the types of transformations?
What is target load order?
Under which circumstances, informatica server creates reject files?
Make a note of the quantity vaults made in informatica?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are the different lookup cache(s)?
What is a repository? And how to add it in an informatica client?
Explain dynamic target flat file name generation in informatica
permutations of mapplet
