what happens when a batch fails?
Answers were Sorted based on User's Feedback
Answer / sai suresh
Grop of sessions are known as Batch.
there are 2 types of batchs are availble
Parlal batch and Sectional batch
Parlal batch:Sessions are executed at the same point of time
Sectional batch: Sessions are executed one after another.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / siva
group of sessions is known as batch.when it fails there is
no transformation of datas between source and targets
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ravi
if it is parallel batch entire batch will failed.
if it is serial batch current session only will failed.
| Is This Answer Correct ? | 1 Yes | 2 No |
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How informatica process data means how informatica works?
can we override a native sql query within informatica? Where do we do it? How do we do it?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
How do you update the records with or without using update strategy?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
how i will stop my workflow after 10 errors
What do you mean by channel change?
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it