 Suppose you have n no.of records @ your flat file and you
have seen some of records are missing while reaching to the
destination. How can you trouble shoot it?
Answer Posted / vikram
While populating to target rejected loads will be loaded in
to bad files and we can cross check the data there and the
other way is run the load in verbose mode to check the
exact reason this happens when the flat file data is not in
correct format.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain sessions and how many types of sessions are there?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is a predefined event?
What does command task mean?
Difference between Target-based loading and constraint-based loading?
what is index?how it can work in informatica
Explain what is informatica metadata and where is it stored?
Briefly describe lookup transformation?
Explain the types of transformations?
What are the different lookup cache(s)?
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
How can you differentiate between powercenter and power map?
What is data movement mode in Informatica and difference between them?
Which transformation is needed while using the Cobol sources as source definitions?
How do you load first and last records into target table?