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. |
How to read files using informatica
This is a discussion on How to read files using informatica within the Data Warehousing forums, part of the Databases category; Hi, I have unix directory, where i got different number of files daily. Now i have to read these files using informatica.I cant use variable or parameter. can anybody suggest ...
|
|||||||
07-31-2007
|
|||
|
|||
|
How to read files using informatica
Hi,
I have unix directory, where i got different number of files daily. Now i have to read these files using informatica.I cant use variable or parameter. can anybody suggest me any idea for this? Reeta 
|
| The Following User Says Thank You to reetasharma108 For This Useful Post: | ||
| Sponsored Links |
|
08-09-2007
|
|||
|
|||
|
Re: How to read files using informatica
Hi,
I need to know few more things before i can suggest you idea. Do u know all the possible set of filenames & their structure which will be coming, even if some fo them don't come? Do u also want to apply some transform logic or u only want to dump them into target using straight pull? Let me know these details. Barun Quote:
|
|
08-16-2007
|
|||
|
|||
Re: How to read files using informatica
Quote:
Quote:
If you have data files in Unix, you can write Sheel scripts why which you can call PL/SQL procedures to load the data. This is by using shell scripting. By using informatica, you can use stored procedure transformations to call the PL/SQL Procedures. Please rectify if any misssing..! Sanghala www.sanghala.com
__________________
Sanghala www.dwforum.net - A Great resource for Data Warehousing Professionals If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
|
|
09-03-2007
|
|||
|
|||
|
Re: How to read files using informatica
I don't think B Arunkumar is wrong. Some times before giving suggestion on the question..we must have known some things clearly. He might have known answer or we can get some clue from them.
I am requesting don't under estimate others.
__________________
Thx SRIRAM N Hope Everything Good
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do you read and write to a serial port? | Geek_Guest | C# | 0 | 07-19-2007 02:15 AM |
| Usage of flat files in Informatica | Geek_Guest | Data Warehousing | 0 | 07-01-2007 05:01 PM |
| How to read a value from resultsetobjet | Geek_Guest | JSP | 2 | 06-15-2007 08:22 AM |
| Read all files as they arrive in directory and then process | Geek_Guest | Oracle | 0 | 03-07-2007 06:34 AM |
| The Read/Write Web | Lokesh M | HTML & CSS | 0 | 06-21-2006 12:58 AM |
All times are GMT -4. The time now is 06:14 PM.
