How to load relational source into file target?

Answer Posted / jang

It should be a direct 1-1 mapping, source having relational
table and Target a Flat file

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is enterprise data warehousing?

611


what is degenerated dimension?

3148


How to load the data from a flat file into the target where the source flat file name changes daily?

572


While migrating the data from one environment to another environment how would you manage the connections?

623


How to start a workflow using pmcmd command?

707






What is a filter transformation?

563


What is workflow manager?

571


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?

654


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

603


update strategy transformation in informatica

638


What is expression transformation?

629


How are the sources and targets definitions imported in informatica designer?

666


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6748


What are the informatica performance improvement tips

609


What is the fact table?

584