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
- 20432 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
my source is junk data how will u remove that junk data by using unix please any one replay me
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is the fact table?
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?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain the use of aggregator cache file?
Explain load alternative records / rows into multiple targets - informatica
what is Active lock explain
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the restrictions of union transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
