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 |
how we can do session partition in informatica any one explain me clearly? thanks advance.
Could any one to tell Fact table Partitioning?
How to load last 10 records of flat file in to the target?
What are parallel querys and query hints?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
What is meant by query override?
Can you use one mapping to populate two tables in different schemas
What are the types of schemas we have in data warehouse.
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
Differentiate between mapping parameter and mapping variable?
How do you join more than 3 flat files in informatica?