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 would you copy the content of one repository to another repository?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the types of lookup transformation?
What are the various types of transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is the meaning of decode in informatica?
What are data-driven sessions?
In informatica workflow manager, how many repositories can be created?
What are pre and post-session shell commands?
Can we create multiple integration service on single repository?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is informatica etl tool?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is workflow monitor?