Interested to Buy Any Domain ? << Click Here >> for more details...
Without source how to insert record to target?
- 6 Answers
- 20001 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 |
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
what is polling?
How the facts will be loaded? explain
What are the types of lookup transformation?
What are active transformations? Name them.
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
Why update strategy and union transformations are active? Explain with examples.
How to call shell scripts from informatica?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is informatica etl tool?
lookup transformation with screenshots
Teradata 
