After dragging the ports of 3 sources
sqlserver,oracle,informix to single source qualiofier can
we map these ports directly to target and how?
Answers were Sorted based on User's Feedback
Answer / rao
How can you join 3 heterogeneous sources to a single source
qualifier?.
For this you need to use 2 joiner transformations and the
resulted cloumns can be connected to the target.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / veeru
No,
By joining the three sources, we can load in to the target
| Is This Answer Correct ? | 0 Yes | 5 No |
what r the transformations that r not involved in mapplet?
write a query for how to eliminate the duplicate rows without using distinct?
Why should we use star schema in datawarehouse design?
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
What is metadata reporter?
how many session run unix environment what command using ?
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani
What is deployemnt groups, Lables, query and dynamic deployment group.
how will you remove the duplicate records from flat file without using sorter?
What is the reusable transformation?
What is an expression transformation in informatica?