There are n numbers of flatfile of exactly same format are
placed in a folder .Can we load these flatfile's data one
by one to a single relational table by a single session??
Answer Posted / rekha
YES YOU CAN DO IT BY USING FILE REPOSITORY
U CAN PLACE THAT FOLDER IN THE SESSION PROPERTIES
Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Where are the source flat files kept before running the session?
What is decode in informatica?
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?
How can we use mapping variables in informatica?
What is joiner transformation in informatica?
What are the types of data warehouses?
What is status code in informatica?
What are the advantages of using informatica as an etl tool over teradata?
Explain transaction control transformation in informatica
How many transformations can be used in mapplets.
How to create Target definition for flat files?
What is the need of etl tools?
How can a transformation be made reusable?
explain abt ur project architecture?