Interested to Buy Any Domain ? << Click Here >> for more details...
i have two source data there is no pk,fk how to join the
two sources
- 5 Answers
- 11598 Views
- TetraSoft, I also Faced
- E-Mail Answers
Answer Posted / ash
use joiner and create 2 ports in jnr and assign the default value 1 to each of the ports.
make sure that 1 port is master port and [ the other post is detail]. Now give the condition as new-masterport=new_detailsport.
This will give the cartesian product type of join.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you remove duplicate records in informatica? And how many ways are there to do it?
Where can we find the throughput option in informatica?
How to generate sequence numbers without using the sequence generator transformation?
What is a repository? And how to add it in an informatica client?
What are ETL Tools?
Enlist the tasks for which source qualifier transformation is used.
What is transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
can you please explain me pre session and post session options?
What are batches?
If informatica has its scheduler why using third party scheduler?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is meant by lookup transformation? Explain the types of lookup transformation?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is rank transformation in informatica
