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
- 12511 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
how to load dimension table and fact table. plz tell me the steps.
Slowly changing dimensions, types and where will you use them
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Explain the features of connected and unconnected lookup.
can we override a native sql query within informatica? Where do we do it?
What is meant by lookup transformation? Explain the types of lookup transformation?
How to create the source and target database connections in server manager?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can you generate reports in informatica?
What are the different components of powercenter?
What is resilience time?
explain abt ur project architecture?
Name the different lookup cache(s)?
How can repository reports be accessed without sql or other transformations?
