Interested to Buy Any Domain ? << Click Here >> for more details...
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??
- 9 Answers
- 14516 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / amarnath
create a file list which is nothing but simple .txt file
which contains the name of the each file u want to load and
in session properties make source file as "indirect" and
give the path of the file list that u have created and run
the wkf
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the limitations of joiner transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
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 the difference between mapping parameter and mapping variable?
Can u generate reports in Informatica?
How to extract the informatica rejected data?
How can we improve session performance in aggregator transformation?
What is primary and backup node?
What is the way to execute pl/sql script using informatica mapping?
Explain the features of connected and unconnected lookup.
What is rank index in rank transformation?
How to use procedural logic inside infromatica?
Define joiner transformation?
