Interested to Buy Any Domain ? << Click Here >> for more details...
can we use cartesian join in informatica
- 3 Answers
- 8471 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 |
Slowly changing dimensions, types and where will you use them
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
what is the logic will you implement to load data into a fact table from n dimension tables?
what is the size of your data warehousing?
If the records doesnt satisfy the filter condition where will it go?
what is the difference between repository & Intergration service
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
how can import the data from the flat files?
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
which is better perfomancewise lookup or joiner and why?can anyone give example?
Explain what is informatica metadata and where is it stored?
Teradata 
