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


Please Help Members By Posting Answers For Below Questions

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

1911


What are the basic requirements to join two sources in a source qualifier transformation using default join?

818


What the difference is between a database, a data warehouse and a data mart?

866


What are the measure objects?

900


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3620


How to create the source and target database connections in server manager?

827


What are multi-group transformations?

792


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

9452


4 yrs etl devloper roles and responsibilities?any body give solutions

1855


What does update strategy mean, and what are the different option of it?

846


What are the types of caches in lookup?

780


How might one distinguish in the case of mapping is right or not without associating session?

852


How to load the data from people soft hrm to people soft erm using informatica?

782


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?

2009


How to convert multiple rows to single row (multiple columns) in informatica

1134