What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?
Answer Posted / ghk
This can be handled by using the file list in informatica.
If we have 5 files in different locations on the server and
we need to load in to single target table.In session
properties we need to change the file type as Indirect.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
what is the hint? how to use it to reduce the query processing in program?
What are the different types of transformation available in informatica.
differences between service based and product based?
How can you differentiate between powercenter and power map?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to convert multiple rows to single row (multiple columns) in informatica
What are data-driven sessions?
Performance tuning in UNIX for informatica mappings?
What are the databases that informatica can connect to windows?
can u give example for factless fact table
How can we create index after completion of load process?
Define joiner transformation?
How to update source definition?
What if the source is a flat-file?
How do you migrate data from one environment to another?