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
- 14954 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 the difference between writing a joiner query in ANSI style and THETA style?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is blocking transformation?
How can we remove the duplicates from flat file source?
Please let me know how to make Data masking in informatica..
Define mapplet?
What is the difference between informatics 7x and 8x and what is latest version?
Explain the use of aggregator cache file?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is meant by query override?
What is meant by target load plan?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
