How to delete the data in the target table after loaded.
- 3 Answers
- 7896 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / davankumar p
we have the property in session truncate option.
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
How can you generate reports in informatica?
What is xml source qualifier transformation in informatica?
Explain lookup transformation source types in informatica
What are the new features of Power Center 5.0?
Explain dynamic target flat file name generation in informatica
How might you approve all mappings in the archive all the while?
What is the function of aggregator transformation?
what is song in infrmatica...?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is different between the data warehouse and data mart?
Design time, run time. If you don't create parameter what will happen
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.
explain one complex mapping with logic? sales project?
