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

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

Define mapping and session?

0 Answers   Informatica,

---

What are batches?

0 Answers  

---

can u give example for factless fact table

2 Answers   TCS,

---

How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

Define mapplet?

0 Answers  

---

What is router transformation

4 Answers   CSC,

---

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,

---

What is a joiner transformation and why it is an active one?

0 Answers  

---

. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  

---

How to delete duplicate records in a flat file source?

2 Answers  

---