Interested to Buy Any Domain ? << Click Here >> for more details...
There are 4 source files which contains same metadata create target that should display the file name along with record
please send answer with mapping
- 3 Answers
- 8863 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / polimera
create pass through mapping
src----> sq--->trg
in source qualifier , double click on it and select
properties tab
her select that "add currenttly proccesed file name"
and in target create one port kto store filename.
in session properties select that indirect method
for this you need to create one list file with all the 4
file paths
then it loads every record with its file name.
please guys if u have any queries let me know,
u can send ur queries to my mail id:
polimera.r.reddy@gmail.com
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is decode in informatica?
Why is sorter an active transformation?
Explain the use of aggregator cache file?
What are ETL Tools?
What is intricate mapping?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is the difference between router and filter?
What is rank transformation in informatica
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What differs when we choose the sorted input for aggregator transformation?
How do you load unique records into one target table and duplicate records into a different target table?
What are the advantages of informatica?
What is dynamic cache?
Why union transformation is an active transformation?
How we can use union transformation?
