how can we load first and last record from a flat file
source to target?
Answer Posted / sudhar
Alternatively we can use the unix pre session command to
read the 1st and last record from the file and place it in
another file and use that new file as source to load the
target table.
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is a pre-defined event and user-defined event?
Do you find any difficulty while working with flat files as source and target?
Mention few advantages of router transformation over filter transformation.
How union transformation is used?
Explain about cumulative Sum or moving sum?
Explain the shared cache and re-cache?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain Dataware house architecture .how data flow from intial to end?
What is rank index in rank transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is informatica? Why do we need it?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Differentiate between Load Manager and DTM?
can you please explain me pre session and post session options?
How to delete duplicate row using informatica?