How will you combine 3 different sources with a single source?
Answers were Sorted based on User's Feedback
Answer / pooja
hi,
please get clear picture on the Question...
1. wherther all 3 source are in same schma or in differt
schme ..
if its in differnt schma means use joiner
if its same schma means u cn override the SQ query
2. if no.of columne and datatype are same for all the 3
source means you can use union trans....
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / madhu
we can use sourcequalifier transformation
or union transformation to combine different source to a
single source
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rkumar.etl
use union transformation or you can write sql override if
you have advance knowledge of table join conditions for the
current database.
Is This Answer Correct ? | 1 Yes | 0 No |
Write the program through which the records can be updated?
What are the types of groups in Router transformation?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
What are the reusable transforamtions?
what is informatica metadata?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Can you create a flatfile target
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
what are the limitations of pushdown optimization technique ? Advance thanks
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
What is Index Caches size?
Parameter and variable differences