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
- 10525 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 workflow manager?
Explain the different lookup methods used in informatica?
Describe expression transformation?
How to create or import flat file definition in to the warehouse designer?
Please let me know how to make encryption and decryption with example?
Briefly define a session task?
How to load last n records of file into target table - informatica
Which version configuration tool used in ur project?
what is the complex transformation you used in informatica
What is a mapplet/worklet in informatica?
Why union transformation is an active transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is joiner change?
