if soource is having 10 records how will u insert 20
records to target
Answer Posted / james
Take two target instances in the mappings
This will load 20 records in the target
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is dynamic cache?
What all are steps in up gradation of Informatica server?
How can we delete duplicate rows from flat files?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain the scenario which compels informatica server to reject files?
What does command task mean?
Make a note of the quantity vaults made in informatica?
what is the Default Source Option For Update Strategy Transformation?
Explain direct and indirect flat file loading (source file type) - informatica
What are the mapping parameters and mapping variables?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How do you convert single row from source into three rows into target?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are Dimensional table?
When do you use sql override in a lookup transformation?