In real time scenario where can we use mapping parameters
and variables?
Answer Posted / kittu
Before using mapping parameters or variables first we hav to declare them in mapping level.After that we can create parameter file with .txt or .prm extension . Mapping parameters are used when the requirement need the values that cannot change with in session where as mapping variables can change the value with in session the best example for mapping variable are we can use them in concept of Increamental Loading and also to generate sequence numbers with out using sequence Generator Transfomation.
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What do you mean by filter transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the reusable transformation?
r u done any partitions in ur project?
How might you approve all mappings in the archive all the while?
Which transformation is needed while using the Cobol sources as source definitions?
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
server hot-ws270 is connect to Repository B. What does it mean?
How to extract the informatica rejected data?
Explain constraint based loading in informatica
How to delete duplicate row using informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Tell me about MD5 functions in informatica
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How do you load first and last records into target table?