Interested to Buy Any Domain ? << Click Here >> for more details...
How u use pdf file in informatica source?
- 2 Answers
- 7285 Views
- Ericsson, HP, IBM, I also Faced
- E-Mail Answers
Answer Posted / isha
Use Unstructured Data Transformation. We can structure this kind of data and then use it in pur mapping.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is an expression transformation?
Can you use flat files in Mapplets.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Define filter transformation?
What you know about transaction control transformation?
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
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the use of code page?
What is the format of informatica objects in a repository?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is mapplet in informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is enterprise data warehousing?
