What is batch and describe about types of batches?
Answers were Sorted based on User's Feedback
Answer / swetha
Grouping of session is known as batch.Batches are two types
Sequential: Runs sessions one after the other
Concurrent: Runs session at same time.
If you have sessions with source-target dependencies you
have to go for sequential batch to start the sessions one
after another.If you have several independent sessions you
can use concurrent batches Which runs all the sessions at
the same time.
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / srikanth nallapati
the above answer was good .any way simply ---->if
dependency is there bittween session's means u should go
for seq batch
if dependency is not there bittween session's means u
should go for concu.. batch
Is This Answer Correct ? | 2 Yes | 2 No |
Can we create out put ports in source qualifier t/r?
Can we create a node as a gateway node and the same node can be assigned to a grid?
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the basic needs to join two sources in a source qualifier?
How to load query faster,so that It will take less time to load?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
what is pre and post sql and what is diff between source presql and target pre sql
Explain direct and indirect flat file loading (source file type) - informatica