i have two source data there is no pk,fk how to join the
two sources
Answer Posted / chandranmca2007
We can create a a dummy columns for both tables using that
dummy column we can join the both tables. If the both
tables have same column means we can using that join the
both tables.
If I wrong please send the answer to my mail id
chandranmca2007@gmail.com
| Is This Answer Correct ? | 21 Yes | 6 No |
Post New Answer View All Answers
How many dimensions are there in informatica?
What is rank index in rank transformation?
How to join three sources using joiner?
Is it possible to define a single node as a Gateway node as well as worker node?
What is meant by active and passive transformation?
Informatica Checkpoints
difference between repository database and repository service?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What does role playing dimension mean?
What is DR strategy for Informatica project?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is meant by a domain?
What do mean by local and global repository?
What do think which one is the better joiner or look up?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?