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
difference between informatica 8.1.1 and 8.6
What is decode in static cache?
What is lookup change?
What is the reusable transformation?
Which transformation should we use to normalise the COBOL and relational sources?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
4 yrs etl devloper roles and responsibilities?any body give solutions
What is sorter transformation?
What is a repository manager?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain joiner transformation in informatica
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is confirmed fact in dataware housing?
Define filter transformation?