i have two source data there is no pk,fk how to join the
two sources
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
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Explain the tuning lookup transformation - informatica
Explain sessions and how many types of sessions are there?
Explain the mapping variable usage example in informatica
How to extract sap data using informatica? What is abap? What are idocs?
Can we create two repositories on same database instance in oracle?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to configure mapping in informatica?
Implementation methodology
What is workflow manager?
What is informatica worklet?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to generate or load values in to the target table based on a column value using informatica etl tool.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs