What are mapping parametres and variables in informatica?
Answer Posted / sid
you can change the value of a parameter in the mapping.The
new value will be stored in the repository.In case in the
next session run you for some reason fail to define the
parameter in the parameter file informatica will pick up
the last value form the reposiroty
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
What is dimensional table? Explain the different dimensions.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
In warehouses how many schemas are there?
What is the sequence generator transformation in informatica?
Why sorter is an active transformation?
What is meant by lookup transformation?
What does command task mean?
Why filter transformation is an active one?
What is data movement mode in Informatica and difference between them?
What is an aggregator transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Enlist the tasks for which source qualifier transformation is used.
Describe the impact of several join conditions and join order in a joiner transformation?
how to load rows into fact table in data warehouse