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

Hi
I have been asked several times the following questions.

1.How does one do incremnental loading
2.Scenario - You are trying to load reasonable amount of
rows into the target table, and its taking a helluva lot of
time.What could be the reasons?

I hate to answer these tw0 , gives me nightmares to even
think of it!!!

3.Tell me any complex situation you have faced( as an
Informatica Developer) and how did you resolve it.

4.tell me any complex mapping that you have done.

All the experienced people out there , please please, reply
to these questions.

Answer Posted / abhinaw prakash

Answer
1.We can do incremental loading by clicking on the check box inside Aggrgator T/R.Use filter transformation before Aggrgator to filter out rows and pass only the changed records to the flow.
2.One of the reasons could be the time its taking to build caches.to answer this more details of the maping is required.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of schemas we have in data warehouse.

963


What is mapplet in informatica?

1060


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.

1295


How do you set a varible in incremental aggregation

1892


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2011


How might one distinguish in the case of mapping is right or not without associating session?

1129


explan ur project architecture?

2073


What does command task mean?

1155


What do you mean incremental aggregation?

1082


Define mapping and session?

1040


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2050


How do you use reject loader.

2612


What is meant by lookup transformation?

1111


What are active and passive transformations?

1089


How to improve the performance of a session using sorter transformation?

1148