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
- 7023 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 are the reusable transformations?
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
Write the program through which the records can be updated?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is the difference between informatica 7.0 and 8.0?
How many number of sessions can one group in batches?
Differentiate between router and filter transformation?
Target increases every day even though no new record was inserted
What is the status code in stored procedure transformation?
In which transformation you cannot drag ports into it?
What is a node in Informatica?
Explain lookup transformation in informatica
What is workflow? What are the components of workflow manager?
What is substr in informatica?
Partition, what happens if the specified key range is shorter and longer
