Answer / ravikumar2614

srikanth answer will work only if the table having only 4 records which r same.
if the table having 10 records, and 4 records r same out of 10 (1st, 5th, 6th, 8th records r same)
in above situation srikanth solution will not work
if wrong please correct me on ravi.info2614@gmail.com

Answer / divesh chasta

informatica solution :
first we will create seq and then filter out the third
record by this condition mod(id%3)=0

from this we can get third record.

Answer / guest

Based on the empid(assuming the persons are employees) us
can fire a quiry on that id.

Answer / pooja

hi all,
suppose 4 emp geting same sal as 4000... select * from emp
where sal=4000 and/having rowid=3

Answer / rag

We can do this by adding the rownum pesudo coulmn in the sql
overrider and take the thrid one since all the values are same,

like select col1,col2,rownum
from tab1
where rownum=3

when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.

1 Answers  

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  

What is facttable granularity?

2 Answers  

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers