Tuesday 3 February 2015

Data Warehousing ETL Interview Questions and Answers (Part4)

31. What are pre-session and post-session options?
These are shell commands that Informatica server performs before running the session. We should have permission and privileges to run the options in Informatica.

32. How do we copy mapping?
The steps to copy mapping are mentioned below: 1.) First, open navigator window 2.) Open the mapping in repository 3.) Click copy

33. What are the tasks done by Informatica server?
Tasks done by Informatica server are: a.) Managing the sessions b.) Running the workflows c.) Tuning performance d.) Scheduling of sessions and workflows

34. What is the difference between source qualifier and joiner transformation?
We need matching keys in source qualifier which we do not need in joiner transformation.

35. What are mapping parameters and mapping variables?
Mapping parameters are parameters which are constant through out the session. They are specified before running the session. Unlike parameters, variables change through out the session.

36. Why do we use partitioning the session in Informatica?
Partitioning achieves the session performance by reducing the time period of reading the source and loading the data into target.

37. To achieve the session partition what are the necessary tasks you have to do?
Configure the session to partition source data.
Install the Informatica server on a machine with multiple CPU’s.

38. Can you copy the batches?
NO

39. How many number of sessions that you can create in a batch?
Any number of sessions.

40. When the Informatica server marks that a batch is failed?
If one of session is configured to “run if previous completes” and that previous session fails.
More Questions & Answers :-
Part1  Part2  Part3  Part4  Part5

No comments:

Post a Comment