Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between mapping parameter and mapping variable?
- 1 Answers
- 1657 Views
- I also Faced
- E-Mail Answers
Answer / ysindhureddy77@gmail.com
A mapping parameter is a user definable constant that takes up a value before running a session. It can be used in SQ expressions, Expression transformation etc.
A mapping variable is also defined similar to the parameter except that the value of the variable is subjected to change. It picks up the value in the following order.
From the Session parameter file
As stored in the repository object in the previous run
As defined in the initial values in the designer
Data type Default values
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the target load order?
Explain grouped cross tab?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
How to load a relational source into file taget?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks
What do mean by local and global repository?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
what is the size of your data warehousing?
Three date formats are there . How to change these three into One format without using expression transformation ?
How to do the error handling of if ur source is flatfiles?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Teradata 
