Without source how to insert record to target?
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 |
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
What are Rapid changing dimensions?
explain different levels in pushdown optimization with example?
What is a filter transformation and why it is an active one?
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the mapping paramaters and mapping variables?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
Which transformation should u need while using the cobol sources as source defintions?