What is use of batch file in informatica?
How many types of batch file in informatica?
Answers were Sorted based on User's Feedback
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 |
Answer / sarthak
u wrote about batches....not about Batch file... its a
different things..
BATCH FILE
A file that contains a sequence, or batch, of commands.
Batch files are useful for storing sets of commands that are
always executed together because you can simply enter the
name of the batch file instead of entering each command
individually.
Is This Answer Correct ? | 11 Yes | 1 No |
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.
What is meant by pre and post session shell command?
Make a note of the quantity vaults made in informatica?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
What is the default source option for update stratgey transformation?
How do you take back up of repository?
What are Rapid changing dimensions?
Explain dynamic target flat file name generation in informatica
What if the source is a flat-file?
what is the difference between Informatica 7.1 and Abinitio?
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500