Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Call unix script through informatica mapping Post 302235021 by Nishithinfy on Thursday 11th of September 2008 02:34:41 AM
Old 09-11-2008
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
 

10 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Informatica - Unix Problem

hi guys, I have to ftp an empty text file dim_trigger.txt form 1 server to another. The target server is mtiftp and i have defined the username and password. Below is the shellscript thats in a file called dim_trigger.ksh #!/bin/ksh # # FTP Bo trigger # HOST= 'mtiftp' USER=... (0 Replies)
Discussion started by: fgene1
0 Replies

2. UNIX for Advanced & Expert Users

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

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

6. UNIX for Dummies Questions & Answers

Unix coding for triggering informatica

Hi, I have very little knowledge with unix and pmcmd. I need help with a issue. I have to see whether a file has been dropped in a particular location/path. If the file dropped I have to check the last modified time, which should be greater than 8pmEST the prior day. If the file has been... (4 Replies)
Discussion started by: redwolves
4 Replies

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

8. Shell Programming and Scripting

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

9. Shell Programming and Scripting

UNIX/Perl script to call informatica source counts

Hi Guys, I am trying below condition . We are using Informatica 9.5 and scheduling certain informatica mapping on set timings .But we are not sure whether the database source table are latest or not .Since its gets updated on daily basis and not sure when it completes.Can we write any unix/perl... (1 Reply)
Discussion started by: Perlbaby
1 Replies

10. UNIX and Linux Applications

UNIX help with informatica

Guys, I have a requirement.Please suggest the way i can : A script is being used to generate a file and send a mail to a source team if the feed for informatica jobs have not reached the server. If the file has not reached the server,the informatica jobs touch 0 byte file after 3 hours and... (2 Replies)
Discussion started by: aliva Dash
2 Replies
transform(3trf) 														   transform(3trf)

NAME
transform - Tcl level transformations SYNOPSIS
package require Tcl ?8.2? package require Trf ?2.1.3? transform ?options...? ?data? callback operation data DESCRIPTION
The command transform reflects the API for a stack channel transformation into the tcl level, thus enabling the writing of transformations in tcl. transform ?options...? ?data? -mode read|write This option is accepted by the command if and only if it is used in immediate mode. See section IMMEDIATE versus ATTACHED for an explanation of the term. The argument value specifies whether to run the read or the write part of the transformation specified via option -command on the immediate data. Beyond the argument values listed above all unique abbreviations are recognized too. -command cmd This option has to be present and is always understood. Its argument is a command prefix. This command prefix will be called by internally whenever some operation of the transformation has to be executed. An empty cmd is not allowed. The exact nature of the various possible calls and their expected results is described later, in section CALLBACK API. -attach channel The presence/absence of this option determines the main operation mode of the transformation. If present the transformation will be stacked onto the channel whose handle was given to the option and run in attached mode. More about this in section IMMEDIATE versus ATTACHED. If the option is absent the transformation is used in immediate mode and the options listed below are recognized. More about this in section IMMEDIATE versus ATTACHED. -in channel This options is legal if and only if the transformation is used in immediate mode. It provides the handle of the channel the data to transform has to be read from. If the transformation is in immediate mode and this option is absent the data to transform is expected as the last argument to the transformation. -out channel This options is legal if and only if the transformation is used in immediate mode. It provides the handle of the channel the generated transformation result is written to. If the transformation is in immediate mode and this option is absent the generated data is returned as the result of the com- mand itself. IMMEDIATE VERSUS ATTACHED
The transformation distinguishes between two main ways of using it. These are the immediate and attached operation modes. For the attached mode the option -attach is used to associate the transformation with an existing channel. During the execution of the com- mand no transformation is performed, instead the channel is changed in such a way, that from then on all data written to or read from it passes through the transformation and is modified by it according to the definition above. This attachment can be revoked by executing the command unstack for the chosen channel. This is the only way to do this at the Tcl level. In the second mode, which can be detected by the absence of option -attach, the transformation immediately takes data from either its com- mandline or a channel, transforms it, and returns the result either as result of the command, or writes it into a channel. The mode is named after the immediate nature of its execution. Where the data is taken from, and delivered to, is governed by the presence and absence of the options -in and -out. It should be noted that this ability to immediately read from and/or write to a channel is an historic artifact which was introduced at the beginning of Trf's life when Tcl version 7.6 was current as this and earlier versions have trouble to deal with characters embedded into either input or output. CALLBACK API
Here we describe the API of the callback command implementing the actual transformation. callback operation data The callback is always called with two arguments, first an operation code followed by data. The latter will be empty for some opera- tions. The known operations are listed below, together with an explanation of the arguments, what is expected of them, and how their results are handled. create/write When called data is empty. The result of the call is ignored. This is the first operation executed for the write side of the transformation. It has to initialize the internals of this part of the transformation and ready it for future calls. delete/write When called data is empty. The result of the call is ignored. This is the last operation executed for the write side of the transformation. It has to shutdown the internals of this part of the transformation and release any resources which were acquired over the lifetime of the transformation. write The operation is called whenever data is written to the channel. At the time of the call the argument data will contain the bytes to transform. The result of the call is taken as the result of the transformation and handed to the next stage down in the stack of transformation associated with the channel. This operation has to transform the contents of data, using whatever data was left over from the last call of the operation. The transformation is allowed to buffer incomplete data. flush/write When called data is empty. The operation has to transform any incomplete data it has buffered internally on the write side. The result of the call is taken as the result of the transformation and handed to the next stage down in the stack of trans- formation associated with the channel. clear/write When called data is empty. The result of the call is ignored. The write side of the transformation has to clear its internal buffers. This operation is called when the user seeks on the channel, thus invalidating any incomplete transformation. create/read When called data is empty. The result of the call is ignored. This is the first operation executed for the read side of the transformation. It has to initialize the internals of this part of the transformation and ready it for future calls. delete/read When called data is empty. The result of the call is ignored. This is the last operation executed for the write side of the transformation. It has to shutdown the internals of this part of the transformation and release any resources which were acquired over the lifetime of the transformation. read The operation is called whenever data is read from the channel. At the time of the call the argument data will contain the bytes to transform. The result of the call is taken as the result of the transformation and posted to the next stage up in the stack of transformation associated with the channel. This operation has to transform the contents of data, using whatever data was left over from the last call of the operation. The transformation is allowed to buffer incomplete data. flush/read When called data is empty. The operation has to transform any incomplete data it has buffered internally on the read side. The result of the call is taken as the result of the transformation and posted to the next stage up in the stack of transfor- mation associated with the channel. clear/read When called data is empty. The result of the call is ignored. The read side of the transformation has to clear its internal buffers. This operation is called when the user seeks on the channel, thus invalidating any incomplete transformation. query/maxRead When called data is empty. The result of the call is interpreted as integer number. This operation is used by the generic layer to determine if the transformation establishes a limit on the number of bytes it (the generic layer) is allowed read from the transformations lower in the stack. A negative result unsets any limit. This has to be used if a transformation employs some kind of end-of-data marker. We cannot allow the generic layer to over- shoot this marker because any data read after it cannot be stuffed back into the core buffers, causing the I/O system to loose data if the transformation is unstacked after it recognized the end of its data. This is a limitation of the I/O system in the tcl core. Returning a positive value will cause the I/O system to slow down, but also ensures that no data is lost. Two examples for such transformations are the data decompressors for zip and bz2. They use the C-level equivalent of this operation to prevent the overshooting. SEE ALSO
trf-intro KEYWORDS
general transform COPYRIGHT
Copyright (c) 1996-2003, Andreas Kupries <andreas_kupries@users.sourceforge.net> Trf transformer commands 2.1.3 transform(3trf)
All times are GMT -4. The time now is 11:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy