Can we use Union Transformation for Heterogeneous sources?
i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Answers were Sorted based on User's Feedback
Answer / chandrababu.sarupuru
Union Transformation allows the Hetrogeneous sources .
So you can join the sources which are having same metadata.
Is This Answer Correct ? | 12 Yes | 0 No |
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
HOW DO YOU CONNECT TO REMOTE SERVER ?
What are the uses of etl tools?
What is repository manager?
How do you change parameter when you move it from development to production.
how can i invoke pmcmd in command line prompt
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
what is the diff b/w union and joiner and lookup?
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
hw cn v elimate dublicate values from lookup without overriding sql?