Answer / Dharmendra Singh Kutiyal

In Informatica, a Connected Transformation is a special type of transformation that connects two or more mappings in a session. It allows data to flow seamlessly from one mapping to another, making it easier to build complex ETL processes.

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1 Answers  

---

what is unique constraint error ?

2 Answers   TCS,

---

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

---

What is sequence generator transformation in informatica?

1 Answers  

---

What are the tasks that can be performed using sq?

1 Answers  

---

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

---

In joiner, how to load Master table in Target?

2 Answers  

---

how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,

---

What are the reusable transforamtions?

2 Answers  

---

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

---

how to insert header after each group.

1 Answers   IBM,

---

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---