What is use of batch file in informatica?
How many types of batch file in informatica?
Answer Posted / pawan
With the batch file , we can run sessions either in sequential or in concurrently.
Grouping of Sessions is known as Batch.
Two types of batches :
1)Sequential: Runs Sessions one after another.
2)Concurrent: Run the Sessions at the same time.
If u have sessions with source-target dependencies u have to go for sequential batch to start the sessions one after another. If u have several independent sessions u can use concurrent batches Which run all the sessions at the same time.
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the tasks that can be performed using sq?
What are the features of complex mapping?
What is the need for an etl tool?
What is the advantage of informatica?
Explain how many types of dimensions are available in informatica?
How does a rank transform differ from aggregator transform functions max and min?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How do you update the records with or without using update strategy?
How big was your fact table
What all are steps in up gradation of Informatica server?
State the limitations where we cannot use joiner in the mapping pipeline?
What is a node in Informatica?
What are the types of lookup transformation?