1 lac of flat fles in source how to load target at a time?
Answer Posted / anoymous
This can be done by File list or File repository. Create
rep.txt file list in that write all the paths of the i lac
flat files.
in session level set the following attributes
source file name indirect
source file directory filelist path address
source file name rep.txt
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between mapping parameter and mapping variable?
What are the performance considerations when working with aggregator transformation?
State the differences between sql override and lookup override?
what is Active lock explain
Design a mapping to load the cumulative sum of salaries of employees into target table?
How we can create indexes after completing the load process?
What is the use of target designer?
What is update strategy transform?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the maplet?
What does cheating measurement mean?
How can one identify whether mapping is correct or not without connecting session?
What is the difference between a repository server and a powerhouse?
What are the data movement modes in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?