Interested to Buy Any Domain ? << Click Here >> for more details...
Any one tell me some 5 session failure in real time?And why
problem occur how to solve the issues?
- 1 Answers
- 4523 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer / ali
if u config wrong relational coonnections in workflow manager, session failed.
2)if u enable bulk load without droping indexes in tgt table, run a session the session get failed.
3)in workflow manager eventwait task waiting for particular time, then the indicator(file) not found, session get failed.
4)while sql override in s.q t/r,u miss any func in query, then (mapping valids) session failed? write correct sql and execute it session succeess.
5)the tgt table has pk , but u r loading duplicated data then session get failed( note:when u put 0 for "stop on errors" property it allows any number of non fatal errors)
| Is This Answer Correct ? | 0 Yes | 0 No |
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are the tuning techniques you applied during your last project
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
In which circumstances that informatica server creates Reject files?
How will u find weather dimension table is big in size of a fact table?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to improve the performance of Aggregate transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
What is the status code?
Teradata 
