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 / sankar
FOR THOSE FLAT FILE WE CREATE A LIST FILE.IN THAT LIST FILE
WE CAN ENTER FLAT FILE DIRECTRIES.
THEN GO TO SESSION
SOURCE TYPE:INDERECT
SOURCE DIRECTOTRY:LIST DIRECTORY
SOURCE FILENAME:LIST.TXT
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is enterprise data warehousing?
tell me 5 session failure in real time how can you solve that in your project?
Why union transformation is an active transformation?
Different circumstance which drives informatica server to expel records?
How is union transformation utilized?
Differentiate between reusable transformation and mapplet.
What is a repository manager?
Did u used latest transformations of 8.6.0? for what?
Which is the t/r that builts only single cache memory?
Enlist the various types of transformations.
What is target designer and target load order?
Design time, run time. If you don't create parameter what will happen
What is DR strategy for Informatica project?
What is olap (on-line analytical processing?
What are the advantages of using informatica as an etl tool over teradata?