Script to check ETL standards in an Informatica mapping


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Script to check ETL standards in an Informatica mapping
# 1  
Old 04-02-2013
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 start with wf.

Please let me know the solution


Regards,
Madhuri
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. 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

2. Shell Programming and Scripting

Informatica post session shell script

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

3. 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

4. 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

5. Shell Programming and Scripting

Linux script to check the informatica log

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

6. Shell Programming and Scripting

UNIX script to check file and start the informatica server

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

7. Shell Programming and Scripting

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... (0 Replies)
Discussion started by: informaticalabs
0 Replies

8. UNIX for Dummies Questions & Answers

Call unix script through informatica mapping

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

9. Shell Programming and Scripting

Reg: Shell script ran using informatica

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
Login or Register to Ask a Question
pamusb-check(1) 						      PAM_USB							   pamusb-check(1)

NAME
pamusb-check - simulates pam_usb authentication SYNOPSIS
Usage: pamusb-check [--help] [--debug] [--config=path] [--service=name] [--dump] [--quiet] <username> DESCRIPTION
pamusb-check can simulate authentication through the pam_usb engine. It is useful for both testing purposes (to check the pam_usb configu- ration without having to try with a real program), but also for scripting. pamusb-check's exit code is 0 if the authentication was success- ful, 1 otherwise. It is used by pamusb-agent to check the device. EXAMPLES
$ pamusb-check scox o Authentication request for user "scox" (pamusb-check) o Device "creative" is connected (good). o Access granted. $ pamusb-check --service=su scox o Authentication request for user "scox" (su) o Device "creative" is connected (good). o Access granted. $ pamusb-check --dump scox Configuration dump for user scox (service: pamusb-check): enable : true debug : false quiet : false color_log : true one_time_pad : true probe_timeout : 10 hostname : helium system_pad_directory : .pamusb device_pad_directory : .pamusb OPTIONS
--help, -h Show summary of options. --debug, -D Shows debug messages. --config, -c Use the given configuration file (defaults to /etc/pamusb.conf). --service, -s Service name to be used for authentication (defaults to pamusb-check) --dump, -d Dump the configuration, but do not try to authenticate --quiet, -q Quiet mode BUGS
Please send bug reports to the pam_usb mailing list. AUTHOR
Andrea Luzzardi <scox@sig11.org> September 12, 2007 pamusb-check(1)