my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?
Answer Posted / abhishek
Through normalizer it is possible just give all feild's
occurance as 2 time and link it from source. It will work.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the databases that informatica can connect to windows?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is expression transformation?
Explain the difference between a data warehouse and a data mart?
In informatics server which files are created during the session rums?
Explian the Process of deployment groups in informatica
Define mapplet?
Explain in detail about scd type 1 through mapping.
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.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain the aggregator transformation?
can we override a native sql query within informatica? How do we do it?
What is standalone command task?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
explan ur project architecture?