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
- 24360 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / dada
Hi Guys,
We can use union transformation to join 100 tables.but the
thing is it should be same structure.by using one union we
can do it. for ex all 100 tables have same order,datatype
(std_name,loc,dept) then only we can do it by union.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are different types of transformations available in informatica?
What is meant by incremental aggregation?
How to handle decimal places while importing a flatfile into informatica?
Mention a few design and development best practices for informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are some examples of informatica etl programs?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
How can we create index after completion of load process?
What is the difference between STOP and ABORT options in Workflow Monitor?
How union transformation is used?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Which development components of informatica have the highest usage?
