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

Hi I have two sources like A, B. My source A contain 10000
million records from that i need 20 attributes. My source B
has also same 10000 million records from that i need only 1
attribute. By using Joiner i have to load into target? Is
there any issue regarding this? if issue is there how to
tune this mapping in best way?

Question Posted / manojdubba

Answers were Sorted based on User's Feedback



Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attr..

Answer / anu

IF 2 SOURCES ARE RELATIONAL USE SQ T/R
WRITE MANUVAL QUERY
first connect requrired 16+1 attributes to furter t/r or target
select required columns and in where condition write matched condition

if there is no common column go to joiner create sequence in both sources then compare sequence in join vondition

Is This Answer Correct ?    1 Yes 0 No

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attr..

Answer / muni

take B table as master....A table as a detail.... so we can reduce serch process in joiner
than based on which column we are going to do join create a index on it

i hope it will give gud per'mance
if i i am worng plz create it

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,

Define enterprise data warehousing?

0 Answers  

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  

explain about informatica server architecture?

1 Answers   IBM,

tell me the push down optimization

2 Answers   Wipro,

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

What is InformaticaPowerCenter?

0 Answers   Informatica,

How many transformations can be used in mapplets.

0 Answers  

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,

can session assigned multiple mappings or not?

2 Answers   Zensar,

What is expression transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories