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
- 8166 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
Mention some types of transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Separate from an archive server and a powerhouse?
What are the performance considerations when working with aggregator transformation?
What are batches?
How do you promote a non-reusable transformation to reusable transformation?
Where can we find the throughput option in informatica?
Differentiate between sessions and batches?
Explain the code page compatibility?
What are the popular informatica products?
What is the different lookup cache(s)?
What are the different components of powercenter?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is Data Caches size?
