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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / shaik

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

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

What are the differences between oltp and olap?

0 Answers  

What is the use of an aggregator cache file?

0 Answers  

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,

can anyone suggest best free Talend data integration training online

0 Answers  

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

How to delete duplicate row using informatica?

0 Answers  

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,

For more Informatica Interview Questions Click Here
Categories