if i am having 10 records in source, i want 20 records in
target...how will you do it
Answer Posted / jz
drop unique constraint in target table and select only
insert in session target properties run the session twice.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What are the differences between oltp and olap?
How to load last n records of file into target table - informatica
What is workflow? What are the components of workflow manager?
pmscmd startworkflow -sv
What is aggregate cache in aggregator transformation?
What are the databases that informatica can connect to windows?
Under which circumstances, informatica server creates reject files?
How we can use union transformation?
What is the use of target designer?
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.
Differentiate between reusable transformation and mapplet.
Do you find any difficulty while working with flat files as source and target?
What is informatica? Why do we need it?
What is resilience time?
What is dimensional table? Explain the different dimensions.