GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 311 of 326    Print  
Adding Values to a Column
How to add values to a column present in target file which column is not present in source file?


  
Total Answers and Comments: 2 Last Update: July 27, 2009     Asked by: PrathimaReddy 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
January 07, 2009 06:10:23   #1  
jayanthidinesh Member Since: January 2009   Contribution: 1    

RE: Adding Values to a Column

If the target column is coming as NULL value from source You can give a default value by adding a column in expression transformation ad below.

COLUMN_NAME (The datatype and value filed will populate. Change it) '-1' or 'DEFAULT'

The value to the target column is defaulted to value of -1 or it can be mentioned as default depending on the datatype in the target table.

Either the column can be directly fetched from source table and given a default value or Add an column in the expression transformation by providing default value to link to target table.

Regards


Jayanthi


 
Is this answer useful? Yes | No
July 27, 2009 09:51:27   #2  
mythili.ki Member Since: July 2009   Contribution: 1    

RE: Adding Values to a Column
Create a port in expression transformation and do calculation whatever you need for the target or assign default value for that port and just pass that to target.
 
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

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

In a Flat File source there r Null as well as Blank values .If u r doing the profiling for that source ,how do u gete counts for the Null and Blank separately instead of getting them as one countThanksManish
View Question | Asked by : MAnish

Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data.
Read Answers (3) | Asked by : boobathi

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 (2) | Asked by : mayur

I have a datatype as varchar2 in source table and when I load the data in the target table it is mapped to nclob datatype.when I run the mapping , there are junk values in my target table which has nclob datatype.Could you please let me know how to solve the issue.Thanks in advance
Read Answers (1) | Asked by : mhnoor


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)?
View Question | Asked by : lokendra

Can anyone tell me how to create time dimension? Do we have to use type1,2,or3 for creating time dimension or we can just create it by using only expression transf and a date column from the source?Thanks in advance.
Read Answers (3) | Asked by : monica


 Sponsored Links

 
Related Articles

jQuery - Column Highlighting

Learning jQuery Column Highlighting It can be a nice user interface enhancement to visually remind the user of what has been done in the past By highlighting the column that was most recently used for sorting we can focus the user s attention on the part of the table that is most likely to be releva
 

Assign values during declaration

How to assign values during declaration of variables Declaring variables tells the compiler the data type the variable is assigned and no storage area is allocated during this stage. It is possible to assign values during declaration itself. For example, consider the following program: main() {
 

Passing values to JavaScript Function

Passing values to JavaScript Function In this JavaScript Tutorial you will learn about how to pass values to and also how to return values from a JavaScript function mosgoogle center Passing Values to function Values can be passed to a function as parameters The general syntax for passing values to
 

CSS3 Multi Column Feature

CSS3 Multi Column Feature CSS3 Multi Column Module is a vital feature present in CSS3 This feature enables users to flow the content of an element into multiple columns The CSS3 Multi Column Module is a important feature because it gives users the following features or advantages there is no need to
 

ASP.NET 2.0 : Adding Sorting and Paging in GridView

ASP NET 2 0 Free Training Adding Sorting and Paging in GridView In this tutorial you will learn adding sorting and paging in a GridView Control Implement Two Column Sorting Create Code for Custom Sorting Editing the GridView control data Deleting Displayed Records Inserting Records and Using Templat
 

ASP.NET 2.0 Tutorials : Adding Web Parts at Run Time

ASP NET 2 0 Tutorials Adding Web Parts at Run Time In this tutorial you will learn how to add Web Parts at run time and To test the Web Parts catalog mosgoogle To allow users to add Web Parts at run time 1 Open the Start aspx page and switch to Design view 2 From the WebParts tab of the Toolbox
 

Visual Studio Adding Controls to Windows Form

Visual Studio Adding Controls In this tutorial let s discuss about Adding Controls to a Windows Form Adding Controls using Windows Forms Designer Adding Controls Dynamically and Setting properties of Controls Sample source codes used in this tutorial are included Forms are containers for control obj
 

Setting and Adding Properties to Windows Form

Setting and Adding Properties to a Windows Form In this tutorial we wil leran about Setting and Adding Properties to a Windows Form Using the Visual Designer to set Windows Form Properties Setting Windows Forms Properties programatically and Using Visual Inheritance along with the sample project and
 

JMeter - Adding User Defined Variables

Adding User Defined Variables The User Defined Variables UDV element as shown in the following snapshot is particularly interesting with regards to the test case design we drafted earlier in the table. It allows you to plug values to variables being used in various locations in the Test Plan. The JM
 

JMeter - Adding HTTP Header Manager

Adding Header Manager Another very useful default element is the Header Manager Configuration element. This element can either be added to the Test Plan and configured manually as an afterthought or we can simply use the recorded Browser-derived headers element as included in the recording. mosgoo
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape