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
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
Why update strategy and union transformations are active? Explain with examples.
What are some examples of informatica etl programs?
What is joiner transformation in informatica?
What is repository manager?
Write the different tools in the workflow manager?
Explain joiner transformation in informatica
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
How do you convert single row from source into three rows into target?
r u done any partitions in ur project?
Separate from an archive server and a powerhouse?
What do you mean by blocking transformation?
What is pmcmd command?
tell me about your project functionality
During the running session, output files are created by informatica server. Enlist few of them.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?