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
Is it possible to define a single node as a Gateway node as well as worker node?
Whats there in global repository
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
if we have a delimiters at unwanted places in a flat file how can we over come those.
Target increases every day even though no new record was inserted
How does a sorter cache works?
What are the informatica performance improvement tips
What is meant by lookup transformation? Explain the types of lookup transformation?
EXL informatica Questions
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
While migrating the data from one environment to another environment how would you manage the connections?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How do you convert single row from source into three rows into target?
What is the command used to run a batch?