Interested to Buy Any Domain ? << Click Here >> for more details...
Without source how to insert record to target?
- 6 Answers
- 19703 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 |
Performance wise which is better joiner or look up ? Give me with example?
how to load only the first and last record of a flat file into the target?
What is a dimensional model?
what is degenerated dimension
What is an expression transformation?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
how do u tune queries?
What is a parameter When and where do you them when does the value will be created
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
how you will maintain version?
EXL informatica Questions
Enterprise data warehouse your projects phase by phase explain?
Teradata 
