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 |
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Without using any transformations how u can load the data into target?
What is informatica etl tool?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
How can we improve session performance in aggregator transformation?
how can one eliminate dupliacte data with out using distinct option?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
How to use pmcmd utility command?
how to join two flat files in informatica?