04-11-2010
Help with Informatica Backend Shell Script
Request Any one of your to provide me a script which does the following in a single unix script.
Basically Users will load data in SHARED LINK everyday, should write a UNIX SCRIPT which will ........
1) Unix script should Open the LINK (FTP)
2) Each DIRECTORY in the link contains many .tar.gz (gunzipped) FILES
3) We have to unzip one by one and save into a temporary folder (each unzipped .tar file will have many .unl files)
4)We need to read the data from only three(3) .unl files out of all the available .UNL files in each extracted folder, lets say a.unl, b.unl and c.unl from a folder ABC.tar
I tried a lot with many people across the globe, but couldn't get a proper answer. Came to know about UNIX.com and came here to seek your kind help.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I am not sure whether this is the right place to ask this question...:)
I am working in Informatica PowerCenter 8.1.1 tool and my server is on UNIX. I have got a shell script to copy files from one folder to another.
When I run the script directly from UNIX prompt it is taking 60... (0 Replies)
Discussion started by: sam99
0 Replies
2. UNIX for Dummies Questions & Answers
hi,
i want to call unix script from transformations used in informatica mapping?
can we do it in any way? Please reply ASAP.
We cant use Storep procedure transformation
Thanks in Advance
nishith (0 Replies)
Discussion started by: Nishithinfy
0 Replies
3. Shell Programming and Scripting
Hi Rockers,
I hope u r dng good one. I have a one question is in unix with informatica . I need a unix script to check whether particular file exists in the folder , If it means we have a informatica server , so we can start the informatica server by accessing that file. Every week we have... (0 Replies)
Discussion started by: gurukrishnan
0 Replies
4. Shell Programming and Scripting
Hi,
We are loading 100 + oracle tables using informatica. At the end of the run, we need to verify the informatica log to confirm the rows are loaded properly to target tables.
There are so many detials included in the etllog. But,the part of the informatica log, linux script needs to look... (0 Replies)
Discussion started by: Maya_Pillai
0 Replies
5. Shell Programming and Scripting
It is a basic Perl CGI question, I want to print out "Processing ... " while backend script /script/wait.pl is still running.
But acctually, nothing appeared in browser untill /script/wait.pl finished.
print "Content-type:text/html\r\n\r\n";
print '<html>';
print '<head>';
print... (4 Replies)
Discussion started by: honglus
4 Replies
6. Shell Programming and Scripting
I am poor at scripting.Can any one help me write a script which parametrizes the script here .
#!/bin/bash
`rm file1.txt`
lineCount=0
newRec=1
IFS=`echo "\n\c"`
while read line
do
lineCount=$(($lineCount + 1))
#check is it a... (2 Replies)
Discussion started by: etldev
2 Replies
7. UNIX and Linux Applications
phonon-backend-gstreamer vs phonon-backend-vlc vs phonon-backend-xine
What are the advantages and disadvantages of phonon-backend-gstreamer, phonon-backend-vlc, and phonon-backend-xine. I was reading this and got curious.
... (1 Reply)
Discussion started by: cokedude
1 Replies
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
Hi,
This is regarding a issue we are facing in informatica post session. We place a shell script in informatica job.
The shell script will need to upload a dummy file to another server.The shell script is running fine.However in informatica job not completing and throwing error
It's... (1 Reply)
Discussion started by: nag_sathi
1 Replies
10. Shell Programming and Scripting
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
LEARN ABOUT REDHAT
sendfiles
SENDFILES(1) [nmh-1.5] SENDFILES(1)
NAME
sendfiles - send multiple files via a MIME message
SYNOPSIS
sendfiles [delay] mailpath subject file1 [file2 ...]
DESCRIPTION
The shell script sendfiles, is used to send a collection of files and directories via electronic mail.
sendfiles mailpath "subject" files ...
sendfiles will archive the files and directories you name with the tar command, and then mail the compressed archive to the "mailpath" with
the given "subject". The archive will be automatically split up into as many messages as necessary in order to get past most mailers.
Sometimes you want sendfiles to pause after posting a partial message. This is usually the case when you are running sendmail and expect
to generate a lot of partial messages. If the first argument given to sendfiles starts with a dash, then it is interpreted as the number
of seconds to pause in between postings, e.g.,
sendfiles -30 mailpath "subject" files ...
will pause 30 seconds in between each posting.
Extracting the Received Files
When these messages are received, invoke mhstore once for the list of messages. The default is for mhstore to store the combined parts as
a new message in the current folder, although this can be changed using storage formatting strings. You can then use mhlist to find out
what's inside; possibly followed by mhstore again to write the archive to a file where you can subsequently uncompress and untar it. For
instance:
% mhlist 5-8
msg part type/subtype size description
5 message/partial 47K part 1 of 4
6 message/partial 47K part 2 of 4
7 message/partial 47K part 3 of 4
8 message/partial 18K part 4 of 4
% mhstore 5-8
reassembling partials 5,6,7,8 to folder inbox as message 9
% mhlist -verbose 9
msg part type/subtype size description
9 application/octet-stream 118K
(extract with uncompress | tar xvpf -)
type=tar
conversions=compress
% mhstore 9
% uncompress < 9.tar.Z | tar xvpf -
Alternately, by using the -auto switch, mhstore will automatically do the extraction for you:
% mhlist 5-8
msg part type/subtype size description
5 message/partial 47K part 1 of 4
6 message/partial 47K part 2 of 4
7 message/partial 47K part 3 of 4
8 message/partial 18K part 4 of 4
% mhstore 5-8
reassembling partials 5,6,7,8 to folder inbox as message 9
% mhlist -verbose 9
msg part type/subtype size description
9 application/octet-stream 118K
(extract with uncompress | tar xvpf -)
type=tar
conversions=compress
% mhstore -auto 9
-- tar listing appears here as files are extracted
As the second tar listing is generated, the files are extracted. A prudent user will never put -auto in the .mh_profile file. The correct
procedure is to first use mhlist to find out what will be extracted. Then mhstore can be invoked with -auto to perform the extraction.
FILES
$HOME/.mh_profile The user profile
PROFILE COMPONENTS
Path: To determine the user's nmh directory
Current-Folder: To find the default current folder
SEE ALSO
mhbuild(1), mhlist(1), mhshow(1), mhstore(1). Proposed Standard for Message Encapsulation (RFC-934)
DEFAULTS
`-noverbose'
CONTEXT
None
MH.6.8 11 June 2012 SENDFILES(1)