Interested to Buy Any Domain ? << Click Here >> for more details...
i have different sources in different databases ,that
sources may be
100 tables i want to load these tables in to single target
how to
pearform the task
- 14 Answers
- 24262 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
after reading the above answers i find one is left joining
the tables in the database itself rather than joinng them
in the session using 99 joiners. it would also increase
performance.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
While migrating the data from one environment to another environment how would you manage the connections?
What will be the approach?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the types of lookup transformation?
How to convert multiple rows to single row (multiple columns) in informatica
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Define the various join types of joiner transformation?
server hot-ws270 is connect to Repository B. What does it mean?
How to create the source and target database connections in server manager?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
wf dont have integration severances how you can run?
What are mapplets? How is it different from a Reusable Transformation?
What is a connected transformation?
