Interested to Buy Any Domain ? << Click Here >> for more details...
what are the real time problems generally come up while
doing or running mapping or any transformation?
- 2 Answers
- 7045 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is pmcmd command?
How might one distinguish in the case of mapping is right or not without associating session?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
scenario where i can use only concurrent execution of workflow.
How to do unit testing in informatica?
State the differences between sql override and lookup override?
What is meant by query override?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is union transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are the differences between source qualifier and joiner transformation?
How to improve the performance of a session using sorter transformation?
What is the fact table?
What is repository manager?
