Interested to Buy Any Domain ? << Click Here >> for more details...
Without source how to insert record to target?
- 6 Answers
- 19994 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 |
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
What is a transaction control transformation?
How to configure mapping in informatica?
How do you handle two sessions in Informatica
Roles and Responsibilties of Informatica Production Support Member?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
What is the difference between stop and abort in informatica
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
Teradata 
