Answer Posted / santhosh kumar n
yes we can partitioning,but we can,t splits fact tables
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is informatica metadata?
Differentiate between sessions and batches?
How to do the error handling of if ur source is flatfiles?
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.
How is union transformation utilized?
What is a router transformation?
How do you take back up of repository?
Separate from an archive server and a powerhouse?
How do you convert single row from source into three rows into target?
Can informatica load heterogeneous targets from heterogeneous sources?
Explain what transformation and how many are there in informatica?
How can you differentiate between powercenter and power map?
What is the commit type if you have a transaction control transformation in the mapping?
Explain the different lookup methods used in informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?