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

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

---

what is row level and column level indicator?

1 Answers   TCS,

---

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?

2 Answers   Sapient,

---

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,

---

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

---

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

---

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  

---

generate date / time dimension in informatica

0 Answers   Informatica,

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  

---

What are the different lookup cache(s)?

0 Answers  

---

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---