Answer / raju

No we can,t use cartesian join in informatica

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

Answer / venkateshmalneni

we can use Cartesian join in informatica by using full outer
option in joiner t/r


if am wrong please let me know

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

What is substr in informatica?

0 Answers  

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

---

How an expression transformation differs from aggregator transformation?

0 Answers  

---

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  

---

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,

---

how will you get 21 to 30 record from 50 records?

6 Answers  

---

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

---

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

---

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---

what is incremental data aggregation?

3 Answers   IBM,

---