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

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

840


Briefly describe lookup transformation?

814


How many types of sessions are there in informatica.please explain them?

956


What is data caches/ index caches?

837


What is an Integration service in Informatica?

915


What is a difference between complete, stop and abort?

865


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

867


What are the new features of informatica 9.x in developer level?

795


What is option by which we can run all the sessions in a batch simultaneously?

899


Can you use flat files in Mapplets.

2439


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1819


Why update strategy and union transformations are active?

832


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

892


How to update or delete the rows in a target, which do not have key fields?

930


my source is junk data how will u remove that junk data by using unix please any one replay me

3485