Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
No Answer is Posted For this Question
Be the First to Post Answer
How to generate sequence numbers?
How can you recover the session in sequential batches?
What is difference between maplet and reusable transformation?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
What is enterprise data warehousing?
What is mapping debugger?
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.
Difference Between ETL & ELT?
How can we integrate different flat file data in a single mapping and with in a single execution
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
In which transformation you cannot drag ports into it?