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 / vivek ranjan
I Think that you run the queary
select * from tablename where unique_no = 0 and unique_no =
5.
Definitally you featch 1 and 5 record every time when you
execute queary.
Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
In informatica workflow manager, how many repositories can be created?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How is union transformation utilized?
What is informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to do unit testing in informatica?
What are the main issues while working with flat files as source and as targets ?
How to call shell scripts from informatica?
How to create Target definition for flat files?
How are indexes created after completing the load process?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is workflow? What are the components of workflow manager?
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
Define mapping and session?