Interested to Buy Any Domain ? << Click Here >> for more details...
How will you combine 3 different sources with a single source?
- 3 Answers
- 8643 Views
- I also Faced
- E-Mail Answers
Answer Posted / rkumar.etl
use union transformation or you can write sql override if
you have advance knowledge of table join conditions for the
current database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Mention few advantages of router transformation over filter transformation.
What does cheating measurement mean?
Explain why we use partitioning the session in informatica?
What are the types of data warehouses?
Differences between connected and unconnected lookup?
What is a sequence generator transformation?
Explain Dataware house architecture .how data flow from intial to end?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is rank index in rank transformation?
How many ways are there to create ports?
what is index?how it can work in informatica
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How to elaborate powercenter integration service?
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 do you understand by SOA of Informatica?
