GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 37 of 312    Print  
Hi All,

I need to put the value of a col (request-id) in the text of the body of the post-session success/failure email which I have to send in Informatica. How to achieve this? We cannot, I guess, use a Parameter File for this as it would take the same value everytime and put it in the email. I want to use the value of request-id which will be different on each session run and capture that value in some parameter/variable and use that in session in the post-session email.

Kindly suggest a way to do this.

Regards,
Sree



  
Total Answers and Comments: 2 Last Update: June 25, 2007     Asked by: Tejasree 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 10, 2006 09:21:13   #1  
Motilal Member Since: June 2006   Contribution: 13    

RE: Hi All,I need to put the value of a co...

In the workflow, create one target file populating it with the required column.

Use the file to mail


 
Is this answer useful? Yes | No
June 25, 2007 12:19:09   #2  
N SRIRAM K Member Since: May 2007   Contribution: 115    

RE: Hi All,I need to put the value of a co...
Great, requirement .. I have never even read it.
How would you a column into mail.
Through email you can send a message or you can send no. of rows rej/accepted and all other stuff. Even you can send target file/log file through attaching to the mail.
You can't add a column into it.
Is that column contain single values...I think no...it may have more than one value so it is typical to do this.
But you can do this with Command Task by executing the UNIX script.
Further queries ask me: sriram_kumar at oneindia dot in

 
Is this answer useful? Yes | No

 Related Questions

I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.Please, any one have a solution to this problem(I installed Informatica 7.1 on WINDOWS XP Home Edition, Oracle 10g)Thanks a lot.nagesh
Read Answers (48) | Asked by : nagesh

Latest Answer : Madhu, Here is the statement to start/stop a session....$PM_HOME/pmcmd starttask -s $PM_PMSERVER_PORT -uv USERNAME -pv PASSWORD -wait -f $Folder -w $Workflow $Task#                  ...
Read Answers (6) | Asked by : karthikeyan

Latest Answer : There are two types1.GDR and LDR2.Versioned and NonVersionedWe can use them in combinations, meaningGDR [Versioned/Non Versioned[Default]]LDR [Versioned/Non Versioned[Default] ...

Hi,1.Can anyone explain all the 4 partitions in Informatica and on which table what partition is used?2.Suppose we have 4 columns in a table primary key, 2 string columns and a numeric column? While doing a group by aggregator what is the order that we have to group by?Thanks,Arpita.
Read Answers (3) | Asked by : Arpita

I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.i hav windows server 2003 OSPlease, any one have a solution to this problem

The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use?
Read Answers (4) | Asked by : Deshaireddy

Latest Answer : No GUI mode for informatica in unix. In Unix you cannot design the mappings and workflow as you do in windows. Unix operating sys can only be used to run the jobs, schudule it... Sidhu ...

Can any body tell me the configuration of informatica in UNIX, or if it is lenghty pls send the doc. thanks in advance

Suppose one flat file taking loading time of 3 hrs.How u can reduce that loading time to 1 hr.( No FTP, Not UNIX system to make parallel processing,No splitting file,and all servers and files and targets existing in same system)
Read Answers (3) | Asked by : Jagadeesh

What is the impact of turning versioning on or off for an Informatica repository? What is the impact of versioning on an existing repository and the new repository, when adding a new repository to the repository server?Thanks, Deborah
Read Answers (2) | Asked by : Deborah


 Sponsored Links

 
Related Articles

Adjusting Your Attitude for Success

Adjusting Your Attitude for Success Does the people around you affect your attitude Let’ s face the facts here Each individual has a choice in life It is possible to allow outside factors to have an influence on our goals in life They can have an impact in a negative way by letting people
 

Attitude Development : Visualizing Success

Visualizing Success What is Visualization Visualization is a technique which you can employ to improve your attitude and thus attain success This is an activity that many successful businessmen athletes celebrities and musicians employ as a means of increasing their success even though a lot of th
 

ERP Success cases

ERP Success cases You have probably heard a lot about ERP systems especially about their implementation and its advantages and disadvantages Here you will find that there are no unachievable targets and that every effort brings benefits These are the stories of people who found success through ERP i
 

ERP Human Resources: The Key for Success

ERP Human Resources The Key for Success The intense competitiveness in the global markets demand an improvement in the results In this context it is critical of the management of human resources The concept of Human Resources as a cost generator has to change into a profits generator mosgoogle cente
 

A Good Attitude Leads to Success

A Good Attitude Leads to Success What is the secret to Success There are numerous secrets” out there on attaining success The vast majority of these so called secrets all have one thing in common Attitude mosgoogle center The reasons why people choose not to apply this main secret of s
 

How to achieve looping in C++

How to achieve looping in C In object oriented programming language whenever a block of statements has to be repeated a certain number of times or repeated until a condition becomes satisfied the concept of looping is used mosgoogle center The following commands used in C for achieving looping for
 

What are Critical Success Factors

Critical Success Factors are areas of activity in which favorable results are necessary for a company to reach its goal. Critical Success Factors are intensive used in business organizations as essential guides for the company or project to achieve its mission and goals. For example, one of the Cr
 

What is Change Data Capture

Change Data Capture refers to the process of capturing changes which are made to a production data source. Change Data Capture is typically performed by reading the source of database management software logs. Some of the features of Change Data Capture are It consolidates units of works En
 

What is Data File

In a logical data model, the conceptual data model which is based on the business semantic is being defined. Thus, entities and relationships and corresponding table and column design, object oriented classes, and XML tags, among other things are being laid regardless of the database will be physica
 

What happens when a variable is not initialized in main function?

When a variable is not initialized in main function it contains garbage value. This can be well seen from the example below main() { int x; printf(“%d”,x); z= sample() } sample() { printf(“Testing program”); } Output is   &n
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape