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
- 15326 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
How we can use union transformation?
Could you explain what is enterprise data warehouse?
How do you load only null records into target?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How many ways are there to create ports?
How to improve the performance of a session using sorter transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What you know about transaction control transformation?
What is informatica? Why do we need it?
can u give example for factless fact table
Explain constraint based loading in informatica
What are the settings that you use to configure the joiner transformation?
Explain the different kinds of facts.
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain the difference between a data warehouse and a data mart?
