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
- 9033 Views
- Wipro, I also Faced
- E-Mail Answers
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 your project of banking domian.
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain why we use partitioning the session in informatica?
How do you recover rows from a failed session
Explain lookup transformation source types in informatica
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
Explain what transformation and how many are there in informatica?
tell me the push down optimization
 Informatica Checkpoints
Teradata 
