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 |
What is domain and gateway node?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
How informatica recognizes mapping?
What is the status code in stored procedure transformation?
What is mapplet in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How can you define a transformation? What are different types of transformations in Informatica?
What is the need of an ETL tool?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,