Interested to Buy Any Domain ? << Click Here >> for more details...
Where do you create/define mapping parameter and mapping variable?
- 1 Answers
- 3223 Views
- I also Faced
- E-Mail Answers
Answer / rajesh kumar
We can create mapping parameters and variables in mapping designer/mapplet designer.
We can define the value within the transformation
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
Can we update a target table (without primarykey) by using update strategy transformation?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
what are the real time problems generally come up while doing or running mapping or any transformation?
How an expression transformation differs from aggregator transformation?
What is a surrogate key?
How will you check the bottle necks in informatica? From where do you start checking?
what are cost based and rule based approaches and what is the difference?
What is the use of incremental aggregation?
i have two source data there is no pk,fk how to join the two sources
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
Teradata 
