Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

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

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
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
# 1  
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
# 2  
Old 11-08-2008
No duplicate or cross-posting, read the rules.

Proceed here:

https://www.unix.com/shell-programmin...apping-xm.html

Thread closed.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
Login or Register to Ask a Question