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

How to generate a single mapping for both the historical
and incremental load.

Question Posted / monalidwh

Answers were Sorted based on User's Feedback



How to generate a single mapping for both the historical and incremental load...

Answer / rahul

hi Allen,

i didnt get it.

can you tel what is EOM. y you used month key from monthly
session.

i Question he didnt tell that we are loading on monthly bases.

pls explain it.

Is This Answer Correct ?    1 Yes 0 No

How to generate a single mapping for both the historical and incremental load...

Answer / allen

Used a router on only populate target two in the mapping on
EOM. The table was partitioned by day key and month key.
This required only one running of the mapping.

A second method was to use the a lookup override to provide
the month key from the monthly session. This required
running the mapping twice.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

What is update strategy transform?

0 Answers  

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

r u done any partitions in ur project?

0 Answers   TCS,

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

Explain sessions?

0 Answers  

Sequence generator, when you move from develoment to production how will you reset

0 Answers  

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

Describe two levels in which update strategy transformation sets?

1 Answers  

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

For more Informatica Interview Questions Click Here
Categories