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
Printable View
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]