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

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=reetasharma108;15981]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[/QUOTE]

[QUOTE=barunkumar]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]

[COLOR="Red"][B]Don't know why this Barun is creating confusions to the Guests/Geeks... Please avoid this kind of replying....[/B][/COLOR]

[QUOTE=reetasharma108]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?[/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

I don't think [COLOR="Black"][COLOR="black"]B Arunkumar[/COLOR][/COLOR] 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.
[COLOR="Blue"]I am requesting don't under estimate others.[/COLOR]