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 |
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
In a sequential batch can you run the session if previous session fails?
Can we combine a flatfile and a database table using an UNION transformation?
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 difference between view and materialised view?
what is bitmap index? did u use it?and how to use it in informatica
Mention few advantages of router transformation over filter transformation.
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
In how many ways we can create ports?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
Is snow flake or star schema used? If star schema means why?