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 |
In session log thier should not be a single error how will u do
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
Briefly describe lookup transformation?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
What are the join types in joiner transformation?
what is plsql table?
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
Can anyone please distinguish what is Inner join and Outer join
Explain the scenario which compels informatica server to reject files?
How to fix the etl bugs..Tell me the process?
How to load duplicate records in to a target table which has a primary key?