i have two source data there is no pk,fk how to join the
two sources
Answer Posted / prathap
if the two sources or coming from different sources then we
use joiner transformation and add a dummy prot
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the sql query overwrite in source qualifier in informatica
what is diff b/t sorter t/r and agg have the option sorter property...
Sequence generator, when you move from develoment to production how will you reset
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is confirmed fact in dataware housing?
What is a standalone command task?
How to do unit testing in informatica?
What are the different lookup cache(s)?
How do you load first and last records into target table?
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
Briefly define reusable transformation?
What is difference between a gateway node and worker node?
design of staging area?
How do you load only null records into target?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?