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 / 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
Explain scd type 3 through mapping.
Describe an informatica powercenter?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is dimensional table?
What is the fact table?
What is the benefit of session partitioning?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How we can use union transformation?
How can you differentiate between powercenter and power map?
Define the various join types of joiner transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the different options available for update strategy?
What is data transformation manager process?
What is a repository? And how to add it in an informatica client?
What is data movement mode in Informatica and difference between them?