can we use cartesian join in informatica
- 3 Answers
- 7992 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh
yes we can ,by creating dummy ports in expression transmission like forjoin and tojoin ,in joiner transformation condition is forjoin=tojoin and output is m*n format
| Is This Answer Correct ? | 1 Yes | 0 No |
we can use Cartesian join in informatica by using full outer
option in joiner t/r
if am wrong please let me know
| Is This Answer Correct ? | 1 Yes | 10 No |
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
Differentiate between Load Manager and DTM?
how can one eliminate dupliacte data with out using distinct option?
How do you migrate data from one environment to another?
How can a transformation be made reusable?
Explain lookup transformation is active in informatica
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
While importing the relational source defintion from database,what are the meta data of source U import?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the session task and command task?
What is the need of building a data warehouse?
What is a node in Informatica?
Teradata 
