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
- 23848 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
Differentiate between reusable transformation and mapplet.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Differences between version 7.x and 8.x.
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
can anyone explain me about retail domain project in informatica?
How do you migrate data from one environment to another?
How to do unit testing in informatica? How to load data in informatica ?
What is a snowflake schema?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Enlist the various types of transformations.
What is workflow? What are the components of workflow manager?
How an expression transformation differs from aggregator transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
wat are deployement groups in informatica, how it will be used for developers
What is a connected transformation?
