can we use cartesian join in informatica
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 |
version controlling in informatica?
without table how to come first record only in oracle?
Tell me about informatica architecture.
Three date formats are there . How to change these three into One format without using expression transformation ?
What is souce qualifier transformation it is active or passive
What is different between the data warehouse and data mart?
Enterprise data warehouse your projects phase by phase explain?
How can we eliminate duplicate rows from flatfile,explain?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
How will you update the first four rows and insert next four rows in a mapping?
what is confirmed fact?
What are some examples of informatica etl programs?