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
- 14489 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
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What could be the possible resons of locks by user?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain the tuning lookup transformation - informatica
How is union transformation utilized?
Make a note of the quantity vaults made in informatica?
What are the new features of informatica 9.x developer?
What are the different types of olap? Give an example?
What is domain and gateway node?
What are the types of caches in lookup? Explain them.
What are the modules in Power Center
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Where can we find the throughput option in informatica?
What are the main issues while working with flat files as source and as targets ?
