Interested to Buy Any Domain ? << Click Here >> for more details...
i have ten flat files with same structure,if
i want to load it to single target,and mapping needs to
should show only one source.what will be the steps to taken
to achieve it?/
- 5 Answers
- 12380 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / anoymous
Create a file system with extension .txt in that copy all
the 10 flat file paths.
Now at session level
source type : indirect
File directory : File system path
source file name: Name of file system.txt
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
What is a dimensional model?
Why is sorter an active transformation?
What is an aggregator transformation?
What are roles and groups and benefits of using them?
How to improve the performance of a session using sorter transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the different transaction levels available in transaction control transformation?
How to elaborate tracing level?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Please let me know how to make Data masking in informatica..
How can you increase the performance in joiner transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
