Answer / amar pandey

the major difference is lookup transformation which is
active(returns all the matched rows) in informatica 9.0

Answer / deepika

In informatica 8.6 unconnected lookup transformation returns only one port and in informatica 9 it returns mutiple matched ports.

Answer / ramana

we can select distinct record using union trans in informatica 9x

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

0 Answers  

---

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

---

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

---

WAT IS TEXT LOAD?

3 Answers   Wipro,

---

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

---

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,

---

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---