Interested to Buy Any Domain ? << Click Here >> for more details...
Without source how to insert record to target?
- 6 Answers
- 19742 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 |
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What do you mean by channel change?
how can you load data into target table without leading zeor's
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
How do you promote a non-reusable transformation to reusable transformation?
How to create a non-reusable instance of reusable transformations?
how to load rows into fact table in data warehouse
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
What are two types of processes that informatica runs the session?
What are the static cache and dynamic cache in informatica?
can anyone explain me about sales project in informatica?
What is the benefit of partitioning a session?
Teradata 
