How to load the source table into flat file target(with
columns) in informatica?
Answer Posted / ganesh yadav
source->source.Qul->expres.Tran->target table
in the target desiner select target type as Flat File.
if u want only Header of the table with out data also we can do..
Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
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
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What the difference is between a database, a data warehouse and a data mart?
What are the measure objects?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to create the source and target database connections in server manager?
What are multi-group transformations?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
4 yrs etl devloper roles and responsibilities?any body give solutions
What does update strategy mean, and what are the different option of it?
What are the types of caches in lookup?
How might one distinguish in the case of mapping is right or not without associating session?
How to load the data from people soft hrm to people soft erm using informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to convert multiple rows to single row (multiple columns) in informatica