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
How to load a Dimension ? and how to load a fact table?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the types of data warehouses?
What is a repository? And how to add it in an informatica client?
What is a filter transformation?
Under which circumstances, informatica server creates reject files?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain the pipeline partition with real time example?
What are the static cache and dynamic cache in informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is data transformation manager process?
What is a standalone command task?
What's the layout of parameter file (what does a parameter file contain?)?
Where are the source flat files kept before running the session?
Explain sessions?