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 |
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
How might you approve all mappings in the archive all the while?
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
How to use procedural logic inside infromatica?
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explain pmcmd command usage in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?