Answer / raj

In SQL override write tha fallowing query

select a.id,b.name,b.sal from <table name> a,<table name> b

The above query is nothing but a cartesion product.

Answer / sudheer113

SELECT F1.COL1,F2.COL2,F2.COL3 FROM A F1,A F2 ORDER BY 1,2

Answer / kondeti srinivas

IF IT IS SOURCE FLAT FILE THEN SQL OVER RIDE WILL NOT WORK

IF IT IS FLAT FILE USE UNION TRANSFORMER AND
CONNECT 3 SAME SOURCE STRUCTURES OF FLAT FILES TO UNION T/F AND CONNECT TO TARGET. IT WILL GIVE THE REQUIRED OUTPUT

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

---

what is diffrence b/w joner and union transfermation

6 Answers  

---

When to use normalization transformation other than cobol source?

2 Answers  

---

How i can upload the MainFrame source For Informatica ?

1 Answers  

---

Explain what are the different types of transformation available in informatica.

0 Answers  

---

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,

---

What is the reusable transformation?

0 Answers  

---

what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

---

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

---