Interview questions

Informatica interview questions – page 14

484 questions. Tap “Show answer” to check yourself.

  1. In a sequential batch can you run the session if previous session fails?

  2. What are the mapings that we use for slowly changing dimension table?

  3. What is meant by aggregate fact table and where is it used?

  4. How to import oracle sequence into Informatica.

  5. What r the methods for creating reusable transforamtions?

  6. What is source qualifier transformation?

  7. Can anyone explain about incremental aggregation with an example?

  8. How can you say that union Transormation is Active transformation.

  9. What is hash table informatica?

  10. Why we use lookup transformations?

  11. On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

  12. Know the reason why to register a server to the repository is necessary

  14. What is the target load order?

  15. Can u tell me how to go for SCD's and its types.Where do we use them mostly

  16. What are partition points?

  17. How can u work with remote database in informatica?did u work directly by using remoteconnections?

  18. What are the measure objects

  19. What is the default join that source qualifier provides?

  20. What is a command that used to run a batch?

  21. Can you use the maping parameters or variables created in one maping into another maping?

  22. How can you improve the performance of Aggregate transformation?

  23. In realtime which one is better star schema or snowflake star schemathe surrogate will be linked to which columns in the dimension table.

  24. What is the need and when do we use a dynamic lookup cache?

  25. How many types of facts and what are they?

  27. What are the joiner caches?

  28. There are 1000 source tables containing the same data with different file formats,now i want to load into a single target table ..how to achieve ?

  29. What is incremantal aggregation?

  30. Can any one tell me how to run scd1 bec it create two target tables in mapping window and there are only one table in warehouse designer(means target).. so if we create one new table in target it gives error..

  31. 1.can u explain one critical mapping?2.performance issue which one is better? whether connected lookup tranformation or unconnected one?

  32. What is Session and Batches?

Companies that ask Informatica questions

Bending Spoons Interview guide Spiralyze Interview guide Winman Software India Interview guide Namecheap Interview guide Softsquare Interview guide E-Con Systems Interview guide