two types of data are there . one is mainframe and the other
is ascii format . in informatica how can you get both the
data in a single format in ascii .
Answer Posted / guest
just selecting Codepage to Ascii
Is This Answer Correct ? | 0 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 the deliverables?in your project?
What are data-driven sessions?
What is the function of aggregator transformation?
how to load rows into fact table in data warehouse
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How can we improve session performance in aggregator transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the differences between source qualifier and joiner transformation?
What are the differences between a connected lookup and unconnected lookup?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is a stored procedure transformation?
Implementation methodology