Answer / avinash

Expression tranformation is used in data cleansing.

If ur target table consist of not null column and source
table consisting null columns so assign some value in
expression tr.
and then pass data to target.

Answer / shashiall

Source Qualifier Transformation and Expression
Transformation are used for Data cleansing.
Data types ,Date formats,null ..not null
constraints ..these r main things considered in the data
cleansing.

Answer / d.chandrasekar

Hi Friends,

My point of view FILTER AND EXPRESSION TRANSFORMATIONS are
used to data cleansing.

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

---

can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,

---

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---

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  

---

how can u approach u r client

2 Answers   CTS,

---

---

What are the types of caches in lookup? Explain them.

0 Answers  

---

scd methodology?

2 Answers  

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  

---

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

---

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

---