Sponsored Content
Top Forums UNIX for Advanced & Expert Users Can any one share a unix script for validating the export of a mapping which is in XM Post 302256178 by perlamohan on Saturday 8th of November 2008 12:19:15 PM
Old 11-08-2008
Question Can any one share a unix script for validating the export of a mapping which is in XM

Hi,
Can any one share a unix script for validating the export of a mapping which is in XML format.
like my requirment is that when ever we are migrating the mappings or wokflows from development to QA we will take the export of that mapping into an XML file.Insted of reviewing the mapping manually in the mapping designer we need to check the XML in such a way that if the mapping description is empty it should write a warning to a file and if there is any unconnected port the it should write a ERROR stating that the mapping is inVALID etc.
<MAPPING DESCRIPTION =" source file." ISVALID ="YES" NAME ="mstage1_etl" OBJECTVERSION ="1" VERSIONNUMBER ="5">
<TRANSFORMATION DESCRIPTION ="" NAME ="rtr__VALUES" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Router" VERSIONNUMBER ="1">
<GROUP DESCRIPTION ="" NAME ="INPUT" ORDER ="1" TYPE ="INPUT"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" GROUP ="INPUT" NAME ="out_flag_CONTROLGROUPID" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="10" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" GROUP ="GRP_TARGET" NAME ="OFFER_NM1" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="200" REF_FIELD ="OFFER_NM" SCALE ="0"/>
<CONNECTOR FROMFIELD ="OPTIMIZATION" FROMINSTANCE ="Shortcut_to_t_9999_WeeklyAmexReportData_200712101" FROMINSTANCETYPE ="Source Definition" TOFIELD ="OPTIMIZATION" TOINSTANCE ="SQ_Shortcut_to_t_9999_WeeklyAmexReportData_200712101" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="EVENT_TYPE" FROMINSTANCE ="Shortcut_to_t_9999_WeeklyAmexReportData_200712101" FROMINSTANCETYPE ="Source Definition" TOFIELD ="EVENT_TYPE" TOINSTANCE ="SQ_Shortcut_to_t_9999_WeeklyAmexReportData_200712101" TOINSTANCETYPE ="Source Qualifier"/>
</MAPPING>


above is a piece of mapping we need to pick the data from the tag <MAPPING> to </MAPPING>
information like the mapping NAME, number of output ports and for every output port the connection is existing in the connection tag.



please suggest me the outline picture how to implement this task

thanks in advance
perlamohan
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

unix script to export data from csv file to oracle database

Hello people, Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies

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

3. Shell Programming and Scripting

Can any one share a unix script for validating the export of a mapping which is in XM

Hi, Can any one share a unix script for validating the export of a mapping which is in XML format. like my requirment is that when ever we are migrating the mappings or wokflows from development to QA we will take the export of that mapping into an XML file.Insted of reviewing the mapping... (1 Reply)
Discussion started by: perlamohan
1 Replies

4. Shell Programming and Scripting

Mapping name into unix script

Hi, How do i call a mapping name and workflow name of an informatica tool in the unix script inorder to execute the mapping. It would be great if any one of u help me in getting a mapping name in a unix script. Thanks in advance (0 Replies)
Discussion started by: raji35
0 Replies

5. Shell Programming and Scripting

Unix Script for getting date and validating just Hour

Hi, Can someone guide me to write a unix script for getting a hour out of a date command and validating hour to see if its > 7 and < 16. if hours is >7 and <16 then assign a variable value of 0730 and if hour is >16 then assign a variable value of 1630? Help appreciated. Thanks in advance.... (9 Replies)
Discussion started by: zulfikarmd
9 Replies

6. Shell Programming and Scripting

Validating Separator in unix

Hi I have an input CSV file which contains some values Format of file is as follows: 32R01000000003144476;32R01000000029054270;1000;6000;12/12/2007;0382521276;REG;Régulari I just need to validate it whether it is ';' seperated ie (if any other seperator is used it shld give an error) How do... (5 Replies)
Discussion started by: theeights
5 Replies

7. Red Hat

CIFS share re-export NFS

Hi Guys, need help here. i have windows server that share a folder C:/ABCDE i configure samba client in Linux server as /EDCBA and it working fine. then i want to share this /EDCBA to another Linux server using NFS. in the /etc/exportfs i have put /EDCBA - *(rw,no_root_squash) ... (1 Reply)
Discussion started by: prossits
1 Replies

8. AIX

CIFS share re-export NFS

Hi Guys, need help here. i have windows server that share a folder C:/ABCDE i configure samba client in AIX server as /EDCBA and it working fine. then i want to share this /EDCBA to another AIX server using NFS. in the /etc/exportfs i have put /EDCBA... (1 Reply)
Discussion started by: prossits
1 Replies

9. Shell Programming and Scripting

UNIX script to validate the export of a XML-formatted mapping

Can any one please share a unix script for validating the export of a mapping which is in XML format Any help would be great for me. Thanks (4 Replies)
Discussion started by: sampoorna
4 Replies

10. Shell Programming and Scripting

Data export UNIX shell script

Hi, I want to write a shell script which connect to my database with the following credentials : User name : user PWD : rap_user_1 Hostname : app.Unix.Gsm1900.Org Port : 7862 SID : PTNC1 Once connected to DB i want to fetch data with the help of a SQL statement and expoet... (4 Replies)
Discussion started by: neeraj617
4 Replies
VCONSOLE.CONF(5)                                                   vconsole.conf                                                  VCONSOLE.CONF(5)

NAME
vconsole.conf - configuration file for the virtual console SYNOPSIS
/etc/vconsole.conf DESCRIPTION
The /etc/vconsole.conf file configures the virtual console, i.e. keyboard mapping and console font. The basic file format of the vconsole.conf is a newline-separated list environment-like shell-compatible variable assignments. It is possible to source the configuration from shell scripts, however, beyond mere variable assignments no shell features are supported, allowing applications to read the file without implementing a shell compatible execution engine. Note that the kernel command line options vconsole.keymap=, vconsole.keymap.toggle=, vconsole.font=, vconsole.font.map=, vconsole.font.unimap= may be used to override the console settings at boot. Depending on the operating system other configuration files might be checked for configuration of the virtual console as well, however only as fallback. OPTIONS
The following options are understood: KEYMAP=, KEYMAP_TOGGLE= Configures the key mapping table of for they keyboard. KEYMAP= defaults to us if not set. The KEYMAP_TOGGLE= can be used to configured a second toggle keymap and is by default unset. FONT=, FONT_MAP=, FONT_UNIMAP= Configures the console font, the console map and the unicode font map. FONT= defaults to latarcyrheb-sun16. EXAMPLE
Example 1. German keyboard and console /etc/vconsole.conf: KEYMAP=de-latin1 FONT=latarcyrheb-sun16 SEE ALSO
systemd(1), loadkeys(1), setfont(8), locale.conf(5) AUTHOR
Lennart Poettering <lennart@poettering.net> Developer systemd 10/07/2013 VCONSOLE.CONF(5)
All times are GMT -4. The time now is 08:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy