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



what are the real time problems generally come up while doing or running mapping or any transforma..

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 are the real time problems generally come up while doing or running mapping or any transforma..

Answer / rao

mapping is invalid.database driver error .

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  


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

1 Answers  


What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,


What is A complex mapping?

3 Answers   TCS,


What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  






Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,


What are the different components of powercenter?

0 Answers  


When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  


How many number of sessions that u can create in a batch?

3 Answers  


. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  


scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,


PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  


Categories