Why update strategy and union transformations are active?
No Answer is Posted For this Question
Be the First to Post Answer
What are some examples of informatica etl programs?
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 the uses of etl tools?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
Differentiate between sessions and batches?
Can you generate reports in Informatcia?
what is session parameters?
write a query for how to eliminate the duplicate rows without using distinct?
what are presession,postsession success and postsession failure commands ?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)