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
How to handle decimal places while importing a flatfile into informatica?
How do you load only null records into target? Explain through mapping flow.
can we override a native sql query within informatica? Where do we do it?
Where can we find the throughput option in informatica?
Difference between Data and Index Caches?
Is stop and abort are same in informatica?
Explain why we use partitioning the session in informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
How to do unit testing in informatica? How to load data in informatica ?
What are the settings that you use to configure the joiner transformation?
Partition, what happens if the specified key range is shorter and longer
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to partition the Session?
Write the different tools in the workflow manager?
Can you use flat files in Mapplets.