Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

ETL Complex FTP

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting ETL Complex FTP
# 1  
Old 02-20-2007
ETL Complex FTP
Hi Gurus,

I want to perform following task :

I am getting new text file every month in CD format.
Now by using 3rd party ETL tool which is installed in UNIX I want to run the job whose input file will be this file from CD. So I need to FTP text file from my client machine CD drive to UNIX. For this I want to write the script and use this script as before job subroutine in ETL job.

Any ideas gurus plz share?
# 2  
Old 02-21-2007
What is CD format ??
# 3  
Old 02-21-2007
I mean I am getting new txt files in Compact Disk(CD) which I need to FTP to unix from my machine automatically by using a script.

Any ideas ?
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Complex if then else

for i in $(condition ONE);do for e in $(CONDITION TWO);do if ; then command 1 command 2 command 3 else if ; then command 1 command 2 command 3 else if ; then ... (6 Replies)
Discussion started by: elilmal
6 Replies

2. Shell Programming and Scripting

Shell script executed from Informatica ETL tool is spawning 2 processes for one script

Hi, I am having a shell script which has a while loop as shown below. while do sleep 60 done I am executing this script from Informatica ETL tool command task from where we can execute UNIX commands/scripts. When i do that, i am seeing 2 processes getting started for one script... (2 Replies)
Discussion started by: chekusi
2 Replies

3. Shell Programming and Scripting

Script to check ETL standards in an Informatica mapping

Hi, Script to check the ETL standards in an informatica mapping ( xml file ). Example: To check the naming standard of mapping . To check the transformation naming convention. To check the datatypes. To the session name , it should start with s. To check the workflow name , it should... (0 Replies)
Discussion started by: srimadhuri
0 Replies

4. UNIX for Dummies Questions & Answers

Unix Shell Script on Tidal schedular for ETL

Hello I am very new to Unix scripting, I am using informatica etl,which is schedule by tidal enterprise. I have a scenario where assume that Tidal only knows how to run jobs at a given time and does not know how to retry. So i want to know weather can i write a shell script such that... (1 Reply)
Discussion started by: bluestarmoon
1 Replies

5. Shell Programming and Scripting

Unix Script via ETL

while ;do sleep 5; done Hi, We do run the ETL jobs via DataStage. We do have 30 sequences which calls 1 update query. Most of the time when the update query is run by many countries, the ETL job gets hang. Becuase of this we have written a above script. We do in the script i.,e if... (1 Reply)
Discussion started by: dsnaveen
1 Replies

6. Shell Programming and Scripting

Complex Script

hey... i had a big problem with my professor i have 3 simple archives in.txt -> had all timestamps of users logon (100lines) ex. 111111 222222 333333 out.txt -> had all timestamps of users logof (100lines) ex. 111113 222225 333332 commands.txt... (9 Replies)
Discussion started by: beandj
9 Replies
Login or Register to Ask a Question