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 137 of 313    Print  
I have two variable ports v1 and v2; v2 is calculated based on v1. What will be the value of v2 for the first time, if the order of ports evaluation is v2 and v1

  
Total Answers and Comments: 2 Last Update: February 05, 2007     Asked by: kirangvr 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
February 05, 2007 07:36:24   #1  
       

RE: I have two variable ports v1 and v2; v2 is calcula...
The PowerCenter Server does not set the initial value for variables to NULL. Instead, the PowerCenter Server uses the following guidelines to set initial values for variables: Zero for numeric ports Empty strings for string ports 01/01/1753 for Date/Time ports with PMServer 4.0 date handling compatibility disabled 01/01/0001 for Date/Time ports with PMServer 4.0 date handling compatibility enabled
 
Is this answer useful? Yes | No
February 05, 2007 07:37:45   #2  
satyaneerumalla Member Since: August 2006   Contribution: 16    

RE: I have two variable ports v1 and v2; v2 is calcula...
The PowerCenter Server does not set the initial value for variables to NULL. Instead, the PowerCenter Server uses the following guidelines to set initial values for variables: Zero for numeric ports Empty strings for string ports 01/01/1753 for Date/Time ports with PMServer 4.0 date handling compatibility disabled 01/01/0001 for Date/Time ports with PMServer 4.0 date handling compatibility enabled
 
Is this answer useful? Yes | No

 Related Questions

There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)?

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

Latest Answer : CREATE OR REPLACE  PROCEDURE TIMEDIMBUILD   (p_start_date IN DATE,  p_end_date IN DATE)AS  v_full_date DATE;  v_day_of_month NUMBER; v_day_of_year NUMBER;  v_day_full_name VARCHAR2(30); v_week_number  ...

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

Hi all,I am getting the following message when I start theinfa Repository server ..Could not start INFORMATICA Repository SERVER on Local ComputerERROR 1053 : the service did not respond to the start or control request in a timely fashionThis is the first time I found the above problem.Could you plz let me know what might be the reason ..Environment : Win sever 2003 , Oracle 9i and Infa 7.1.1.Thanks in Advance ..Thanks,Priya
Read Answers (2) | Asked by : priya...

In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens?
Read Answers (9) | Asked by : reddy

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
Read Answers (2) | Asked by : Tejasree

Im trying to fill a primary key field of a target using a trigger on the table to insert a sequence number for each insertion of a new row.After running the session im finding that the key column is populated ,but,not in an order. the key field starts with some 75 goes till 200,the again 551 comes and goes till 10500 ,suddenly the next key field is filled with 21 and goes till 72.... is there any reason why this is happening in this reason.FYI : i truncated the table data ,then dropped the seq.
Read Answers (1) | Asked by : mayur

Latest Answer : you have to a string variable to input a date field, and while using it in mapping u need to convert it to date format . to_date(val,'format') ...
Read Answers (1) | Asked by : Prajakta Borkar

How to implement this situation:have one source and one target,while load into the target first delete then insert?
Now I implement it through this way:create two source qualifier both for the same source,then config the target load plan to load into the target by order.but before I load into the target,I need to look-up 
Read Answers (2) | Asked by : Grayva


 Sponsored Links

 
Related Articles

Performing DML Operations on XML Schema Based XMLType Views

Performing DML Operations on XML Schema Based XMLType Views Analyzing the underlying query of the empSch v view discussed in the preceding section you may note that each attribute of the EMP T object used in the select list maps to a certain column of a single table namely emps What this means in pr
 

What is Data Collection Time

Modern Relational Database Management Systems can be configured to collect data at certain events.  In a business, some of the events are sale, order, deposit, pay, request and many more. Events are really business activities in a company.  Big companies, in order to gain competiti
 

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
 

What happens when a variable is not declared in function definition?

Generally in C program the function definition and calling takes the form as given below: main() { int x,y,z; z=sample(x,y); printf(“%d”,z); } sample(x1,y1) int x1,y1; { int z1; z1= x1 - y1; return(z1); } Here what happens is the values x, y gets passed to x1,y1
 

The Right Time To Make A Career Change

Changing careers is one of the most crucial stages in one’s career life. There are employees who get into the career change phase earlier than other employees. But no matter how an employee enjoys his or her current career, there would come a time that an employee would think of shifting c
 

Supply Chain Management : Just In Time

Supply Chain  Management Just In Time Introduction In the realm of supply chain management Just in time” refers to an inventory strategy that it used to improve a business’ s return on investment through a reduction of in process inventory and all related costs Just in
 

Variable, Constants and Data types in C++

Variable Constants and Data types in C In this C tutorial you will learn about variable constants and data types in C rules for defining variable name short int int long int float double long double char bool declaring variables and constants mosgoogle Variables A variable is the storage location in
 

Class-based Object Oriented Programming

Class based Object Oriented Programming Class based object oriented programming is a style that gains inheritance by processing classes as objects The most prominent style of OOP is class based instead of object based With the class based OOP system objects are units that merge states identities and
 

The Connection of the 80/20 Principle With Time Management

The Connection of the 80 20 Principle With Time Management In the early part of the 20th century an economist named Vilfredo Pareto came up with a mathematical system that explained the unequal share of wealth in society He determined that in most societies eighty percent of the wealth is almost alw
 

The Connection Between Time and Money

The Connection Between Time and Money You have probably heard people use the statement time is money" many times While it sounds like a simple statement it is much more complex then you may think There are certain connections that time has with money but there are also some notable differ
 





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