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
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How we can use union transformation?
What is the different lookup cache(s)?
What is the need of etl tools?
How to create a non-reusable instance of reusable transformations?
What is InformaticaPowerCenter?
What is meant by a domain?
How to use pmcmd utility command?
Which version configuration tool used in ur project?
What can we do to improve the performance of informatica aggregator transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Informatica settings are available in which file?
can anyone explain me about retail domain project in informatica?
How do you convert single row from source into three rows into target?
What is the sql query overwrite in source qualifier in informatica