Answer / subbu

select * from table name where name is not null and
age is not null

Answer / karthis4u

select * from table name where name is not null OR
age is not null

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

---

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

---

need for registering a repository server

1 Answers  

---

How many numbers of sessions can one group in batches?

0 Answers  

---

What is the need of an ETL tool?

0 Answers   Informatica,

---

Name 4 output files that informatica server creates during session running?

1 Answers  

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---

What is sorter transformation?

0 Answers  

---

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

---

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  

---

How do you implement scheduling in Informatica?

1 Answers  

---