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 252 of 301    Print  
How to change the target table dynamically?

  
Total Answers and Comments: 1 Last Update: November 19, 2007     Asked by: madhu2732 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 19, 2007 13:46:26   #1  
naresh        

RE: How to change the target table dynamically?
It is not possible to change the target table dynamically. According to me, we can change the connection of the table dynamically by changing the session properties.
 
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 : In Session properties SELECT treat source rows as UPDATE In Target properties of session SELECT Insert, Update works like it updates if row is existing or Insert if the row is not existing. ...

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

What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys?
Read Answers (5) | Asked by : kishore

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

I am asked to create a detailed metadata about ,transformations used in perticular fact table mapping.How do i understand and create write up on what has happened to each port during each tranformations?By right click on port in target definition and choosing backward path , I could get complete path fot that port.Pls. adviseThanks,
Read Answers (1) | Asked by : Adi
Tags : Metadata

Can anyone tell me , How to understand the use of transformations in informatica mapping for particular target port?
Read Answers (8) | Asked by : Adi

In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?How can we draw and wich transformations we r using?and explain logic?
Read Answers (4) | Asked by : Reddy

Hi all,Could anyone tell me why session fails when running a workflow? I don't see any records being inserted to target table though source table has data. There are sufficient permissions to the user who is running workflow and relational connections are pointing to the correct databases. This whole exercise is taking place on windows xp pro and backend database is oracle 10 EE. Any help is appreciated.ThanksKamalnayan
Read Answers (4) | Asked by : Kamalnayan Maramraj
Tags : RDBMS


 Sponsored Links

 
Related Articles

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

jQuery Table Row Finished Code

jQuery Table Row Finished Code The Finished Code Our second example page has demonstrated table row striping highlighting tooltips collapsing expanding and filtering Taken together the JavaScript code for this page is mosgoogle geshibot lang php" document ready function var highlighted
 

jQuery Expanding and Collapsing Table Rows

jQuery Expanding and Collapsing Table Rows The expanding and collapsing behavior added earlier also conflicts with our filters If a section is collapsed and a new filter is chosen then the matching items are displayed even if in the collapsed section Conversely if the table is filtered and a section
 

jQuery Table Row Filtering

jQuery Table Row Filtering Earlier we examined sorting and paging as techniques for helping users focus on relevant portions of a table s data We saw that both could be implemented either with server side technology or with JavaScript Filtering completes this arsenal of data arrangement strategies B
 

jQuery Collapsing and Expanding Table Rows

jQuery Collapsing and Expanding Table Rows When large sets of data are grouped in tables as each year s set of articles are in our News page collapsing or hiding a section s contents can be a convenient way to get a broad view of all of the table s data without having to scroll so much mosgoogle To
 

jQuery Table Manipulation

Learning jQuery Table Manipulation By Karl Swedberg Jonathan Chaffer Better Interaction Design and Web Development with Simple JavaScript Techniques Learning jQuery packtpub com jQuery book Table Manipulation Let em wear gaudy colors Or avoid display Devo Wiggly World" In the first si
 

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
 

SQL Table Commands

SQL Table Commands Overview As mentioned previously in this series of SQL articles, databases are primarily composed of tables. The “columns and rows” structure of the table allows data to be efficiently inserted, manipulated, updated, and deleted from the database. The three mos
 

Top 5 Reasons Why You Need a Career Change

For many people, a change in career takes place more than three times in their life. Reasons for this vary. There are those who make the change because the reality is that people make mistakes in choosing their career paths and would therefore like to correct that by aiming for what they really want
 

Career Change: Tips on How to Look for a New Job

Looking for a new job is a task to do. But if you are changing your career after you have been in the same job for quite some time, then your job search becomes even more difficult. Always remember though that your ultimate goal in working is a good career and not just a good job. So don&rsquo
 





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