my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?
- 10 Answers
- 17326 Views
- Cap Gemini, Wipro, I also Faced
- E-Mail Answers
Answer Posted / naga
Just run the session twice , Setting Session update
properties as Insert and remove distict option/Unique key
constraints in Target
| Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
What do you mean by blocking transformation?
What do you understand by a term domain?
Explain in detail scd type 2 through mapping.
What are the components of Informatica? And what is the purpose of each?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is joiner transformation in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
During the running session, output files are created by informatica server. Enlist few of them.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Enlist the differences between database and data warehouse.
What is meant by query override?
Which version configuration tool used in ur project?
what are factless facts? And in which scenario will you use such kinds of fact tables.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
