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
Answers were Sorted based on User's Feedback
Answer / 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 |
double click the source go to properties tab check the
"ADD CURRENT PROCESSED FILE NAME PORT"
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prakash
A small correction of polimera.r.reddy@gmail.com.
'Add Currently Processed Flat File Name Port' option present
at source definition.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain reference cursor?
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
Why update strategy and union transformations are active? Explain with examples.
What is best approach to load 100 different source files (Different structure) to differet target tables ?
How to eliminate duplicate records in informatica mapping? Explain with an example....
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is the default source option for update stratgey transformation?
Could any one to tell Fact table Partitioning?
how to remove staging area