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 |
What is confirmed fact in dataware housing?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Under which circumstances, informatica server creates reject files?
What are the popular informatica products?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
How to extract the informatica rejected data?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is sql query override? When did u use sql query override?
What is use of batch file in informatica? How many types of batch file in informatica?
Explain transaction control transformation in informatica