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

Question Posted / abhinaw prakash

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

In informatics server which files are created during the session rums?

1107

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1907

How to elaborate tracing level?

1155

What is meant by pre and post session shell command?

1139

What is the advantage of informatica?

1055

Under what condition selecting sorted input in aggregator may fail the session?

1112

How many number of sessions can one group in batches?

1144

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6148

Define pmcmd command?

1028

What is decode in informatica?

1124

what is the size of u r source(like file or table)?

2253

How many ways are there to create ports?

1307

What are the main features of Oracle 8i with context to datawarehouse?

2100

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

2030

Can we create a Integration service without a Repository service and vice versa?

1205