Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can we combine a flatfile and a database table using an
UNION transformation?

Answers were Sorted based on User's Feedback



Can we combine a flatfile and a database table using an UNION transformation?..

Answer / kunkala ramakrishna

both the file and table metadata should same then we can join

Is This Answer Correct ?    15 Yes 0 No

Can we combine a flatfile and a database table using an UNION transformation?..

Answer / surya

You can connect heterogeneous sources to a Union transformation.The transformation merges sources with matching ports and outputs the data from one output group with the same ports as the input groups

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More Informatica Interview Questions

What is the command used to run a batch?

0 Answers  


What are the data movement modes in informatcia?

1 Answers  


hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,


source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,


What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,


Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  


how you will maintain version?

3 Answers   CTS, TCS,


write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


tell me the informatica architecture

1 Answers   Banca Sella, Wipro,


Explain lookup transformation is active in informatica

0 Answers   Informatica,


what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  


Performance tuning( what you did in performance tuning)

0 Answers   Infosys,


Categories