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 are the differences between joiner transformation and source qualifier transformation?
Which version configuration tool used in ur project?
What is the benefit of session partitioning?
What does role playing dimension mean?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Why update strategy and union transformations are active? Explain with examples.
Differentiate between joiner and lookup transformation?
How can we delete duplicate rows from flat files?
explain one complex mapping with logic? sales project?
Explain Dataware house architecture .how data flow from intial to end?
Do you find any difficulty while working with flat files as source and target?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Can we create a node as a gateway node and the same node can be assigned to a grid?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are session parameters ? How do you set them?