Without source how to insert record to target?
- 6 Answers
- 17522 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sudhar
Use the Dual Table as dummy table and use the Normalizer to
generate required number of rows then apply what ever logic
required to populate the Target.
For example you can create a calendar for the entire year
with the one record from the dual table using the normalizer.
But with out any source the mapping cannot be created and u
need some dummy source like the above to populate the Target.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / giri
Without Source means no data upload data arem ethod
1. Source qualifier use to Pre sql and post sql generate sql
query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / krishnakanth
Hi Sudhar........Thanks for the answer. Its really very
helpful.
| Is This Answer Correct ? | 0 Yes | 1 No |
when we dont use aggregator in mapping ?
Differentiate between reusable transformation and mapplet.
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
What is the difference Between Mapping parameter and variable
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
Explain the use of aggregator cache file?
How to update a particular record in target with out running whole workflow?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
What are the features of complex mapping?
What is the fact table?
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
How will u find weather dimension table is big in size of a fact table?
Teradata 
