Interested to Buy Any Domain ? << Click Here >> for more details...
How do you handle decimal places while importing a flatfile
into informatica?
- 1 Answers
- 9386 Views
- I also Faced
- E-Mail Answers
Answer Posted / maruthi
1.)use to_integer('column name','newcolumn)
it works
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
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 are some examples of informatica etl programs?
Explain in detail scd type 2 through mapping.
What are the new features of informatica 9.x in developer level?
Briefly define a session task?
How many dimensions are there in informatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are the different lookup cache(s)?
What are roles and groups and benefits of using them?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How can you validate all mappings in the repository simultaneously?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
scenario where i can use only concurrent execution of workflow.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are the new features of Power Center 5.0?
