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
- 12509 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
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the informatica performance improvement tips
What is union transformation in informatica?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
how tokens will generate?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How union transformation is used?
What are the new features of Power Center 5.0?
What is an expression transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the different types of repositories created using informatica?
Quickly characterize reusable change?
What could be the possible resons of locks by user?
How do you update the records with or without using update strategy?
