11-08-2008
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
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
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,
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
mfontset_lookup
mfontset_lookup(3m17n) The m17n Library mfontset_lookup(3m17n)
NAME
mfontset_lookup - Lookup a fontset.
SYNOPSIS
MPlist * mfontset_lookup (MFontset * fontset, MSymbol script, MSymbol language, MSymbol charset)
DESCRIPTION
Lookup a fontset. The mfontset_lookup() function lookups fontset and returns a plist that describes the contents of fontset corresponding
to the specified script, language, and charset.
If script is Mt, keys of the returned plist are script name symbols for which some fonts are specified and values are NULL.
If script is a script name symbol, the returned plist is decided by language.
o If language is Mt, keys of the plist are language name symbols for which some fonts are specified and values are NULL. A key may be Mt
which means some fallback fonts are specified for the script.
o If language is a language name symbol, the plist is a FONT-GROUP for the specified script and language. FONT-GROUP is a plist whose keys
are FLT (FontLayoutTable) name symbols (Mt if no FLT is associated with the font) and values are pointers to MFont.
o If language is Mnil, the plist is fallback FONT-GROUP for the script.
If script is Mnil, the returned plist is decided as below.
o If charset is Mt, keys of the returned plist are charset name symbols for which some fonts are specified and values are NULL.
o If charset is a charset name symbol, the plist is a FONT-GROUP for the charset.
o If charset is Mnil, the plist is a fallback FONT-GROUP.
RETURN VALUE
It returns a plist describing the contents of a fontset. The plist should be freed by m17n_object_unref().
COPYRIGHT
Copyright (C) 2001 Information-technology Promotion Agency (IPA)
Copyright (C) 2001-2011 National Institute of Advanced Industrial Science and Technology (AIST)
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License
<http://www.gnu.org/licenses/fdl.html>.
Version 1.6.2 12 Jan 2011 mfontset_lookup(3m17n)