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 / 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 -ve test case in your project.
How can repository reports be accessed without sql or other transformations?
What are the different types of olap? Give an example?
What is repository manager?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What all are steps in up gradation of Informatica server?
What are the new features of Power Center 5.0?
What is an expression transformation?
Why do you use Mapping Parameter and mapping variable?
my source is junk data how will u remove that junk data by using unix please any one replay me
Why union transformation is an active transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How to go to the older version for a mapping?