what are the real time problems generally come up while
doing or running mapping or any transformation?
Answers were Sorted based on User's Feedback
Answer / bsgsr
populating null values inti not null columns,
expression errors in the expression editor,
pre n post sql errors,
overflow errors,
unique key constraint violation
and many such
reach me on bsgsr12@gmail.com
Is This Answer Correct ? | 2 Yes | 0 No |
How can you recover the session in sequential batches?
Are there any types of Dynamic Caches in informatica
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
what is the difference between stop and abort
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
Difference between task flow and linear task flow
Differentiate between sessions and batches?
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar