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
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
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
Don't know why this Barun is creating confusions to the Guests/Geeks... Please avoid this kind of replying....Originally Posted by barunkumar
Originally Posted by reetasharma108
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
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
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