GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 236 of 327    Print  
What condition should be specified in the Router transformation expression editor to get unique rows, duplicate rows and null values on a particular column in 3 different target databases?

  
Total Answers and Comments: 0 Last Update: October 10, 2007     Asked by: meghana6 
  
 Sponsored Links

 

No answers are posted for this question yet.
Be the first to answer it!


 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 : We can update the target table, by using the update override in target definition. it will update based on non key columns. ...

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

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 (9) | 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 (6) | 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

I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup transformation with example...
Read Answers (2) | Asked by : kalpana


 Sponsored Links

 
Related Articles

ODP.NET - Retrieving Multiple Rows on to the Grid

ODP NET Retrieving Multiple Rows on to the Grid In the previous section we tried to retrieve only one row using OracleDataReader In this section we will try to retrieve more than one row or a result set and populate a DataGridView on a WinForm mosgoogle The following code lists out the details of al
 

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 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 - 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() {
 

Operator, Operand and Expression in C

Operator, Operand, and Expression in are symbols which take one or more operands or expressions and perform arithmetic or logical computations. Types of operators available in C are as follows: Arithmetic Assignment Logical/relational Bitwise These have operators under each
 

Distributed Databases

Distributed Databases Overview Suppose you created a database for a web application a few years ago. It started with a handful of users but steadily grew, and now its growth is far outpacing the server’s relatively limited resources. You could upgrade the server, but that would only stem t
 

Relational Databases

What is a Relational Database? Popular, modern databases are built on top of an idea called “relational algebra”, which defines how “relations” (e.g. tables and sequences in databases) interact within the entire “set” of relations. This set
 

Getting Ahead with Databases

Database Overview You have been using databases for a few years, and you think you are at the top of your game. Or, perhaps, you have been interested in databases for a while, and you think you did like to pursue a career using them, but you do not know where to start. What is the next step in terms
 

Databases Are Fun!

Have you ever wondered the name of a movie you watched years ago, and although it was on the tip of your tongue, the few words of that short title just wouldn’t come out? What about a book you read when you were younger that had a particularly compelling story to tell, and despite every ef
 

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