Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / xx
Its always better to use reg_replace check the below link
https://etltechsolutions.wordpress.com/category/informatica/
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the main issues while working with flat files as source and as targets ?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How we can create indexes after completing the loan process?
Enlist the advantages of informatica.
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
What is confirmed fact in dataware housing?
What are the new features of informatica 9.x in developer level?
How can we update a record in the target table without using update strategy?
What is a predefined event?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
how to load rows into fact table in data warehouse
What is a pre-defined event and user-defined event?
How would you join a node to the already existing domain?
What is the scenario which compels informatica server to reject files?
What is the difference between writing a joiner query in ANSI style and THETA style?
