Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on Append data to a target file within the Data Warehousing forums, part of the Databases category; In Informatica, How to append data to a target file? NOTE : [This question was asked by Ramakrishna, I am posting it in proper forum]...
|
|||||||
|
|||
|
Append data to a target file
In Informatica, How to append data to a target file?
NOTE : [This question was asked by Ramakrishna, I am posting it in proper forum] |
| The Following User Says Thank You to JobHelper For This Useful Post: | ||
| Sponsored Links |
|
|||
|
Re: Append data to a target file
Hi
I am not sure if this is the best possible way , but just a suggestion. Write a new target file and then in the post session command concat / append to the master file. |
|
|||
|
Re: Append data to a target file
It's going to be a long way depending on your extraction requirements, like cleansing, scrubbing etc. However, if you through with this process and ready to append the records in your target area then from your cleansed records (after the expression, joiner, lookup etc.). Inside the mapping you can link the ouput ports of your last transformation going to the input ports of your STG or target definition.
|
|
|||
|
Re: Append data to a target file
sorry, just to add up, make sure you configure your session properties, instance, connections, treat source file as, something like that. then you need to run the workflow.
|
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Listen to any PDF file!!! | Shivanna | Geeks Lounge | 7 | 01-13-2009 09:18 AM |
| File Types in Linux | Bessie | Unix/Linux | 2 | 04-25-2007 06:19 AM |
| Can we edit the file | fred | Windows | 1 | 09-13-2006 01:06 PM |
| Query on Retrieving File | sripri | Unix/Linux | 1 | 08-06-2006 03:29 PM |
| C Programming - File management in C | Lokesh M | C and C++ | 0 | 05-31-2006 04:35 PM |