Answer Posted / subhrangshu

Sequence generator may create issue in case of partitioning. The duplicate keys get generated in sequence generator. We cannot have cannot have multiple table feeder processes.
Then, we can use either Oracle database sequences or Lookup / Expression transformation to create sequence numbers. Although, Oracle sequences are better as it
will also handle the case where there are other sources feeding the Target under consideration other than ETL. Yes, there is slight hit in performance, but it's minor in most situations.

What are the main issues while working with flat files as source and as targets ?

1213

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2189

---

What is the difference between source qualifier transformations source filter to filter transformation?

1089

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2322

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1791

---

What are the data movement modes in informatica?

1206

---

What are the mapping parameters and mapping variables?

1264

---

What are the designer tools for creating transformations?

1155

---

What are the measure objects?

1251

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1170

---

What is the need for an etl tool?

1097

---

How to convert multiple rows to single row (multiple columns) in informatica

1424

---

How to update a particular record in target with out running whole workflow?

1622

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2182

---

What is incremental aggregation?

1132

---