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
Answer Posted / suresh
hi rachana
if here there are 100 tables
at that time we have to use 99 joins or is there any
another process for joining the 100 tables from diff
sources into to a single target
let me know if u know the answer
thanks for u r considiration
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
explain abt ur project architecture?
What is the cumulative sum and moving sum?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is the benefit of session partitioning?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
permutations of mapplet
How an expression transformation differs from aggregator transformation?
Is there any way to read the ms excel datas directly into informatica?
What is the difference between stop and abort in informatica
Slowly changing dimensions, types and where will you use them
how tokens will generate?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
write a query to retrieve the latest records from the table sorted by version(scd)
Explain sessions and how many types of sessions are there?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me