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
- 14475 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srinu
Yes BZZ,,,
After assign the folder path in Source path,
We have to change source Type as INDIRECT in Session
properties.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is the need of etl tools?
How to create a non-reusable instance of reusable transformations?
What is rank transformation?
pmscmd startworkflow -sv
what is song in infrmatica...?
What is the difference between stop and abort in informatica
To import the flat file definition into the designer where should the flat file be placed?
Why do we need informatica?
Explain how to import oracle sequence into informatica?
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
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
server hot-ws270 is connect to Repository B. What does it mean?
What you know about transaction control transformation?
Reusable transformation and shortcut differences
