Answer Posted / santosh kumar sarangi

:TU means data coming as input to target.

Just use the query in pre or post sql in target or session.

Let me know if any thing wrong.

Thanks & regards
Santosh kumar Sarangi

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

1080

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1077

---

How do you load only null records into target?

1216

---

Scheduling properties,whats the default (sequential)

1956

---

Target increases every day even though no new record was inserted

1581

---

How to handle decimal places while importing a flatfile into informatica?

1192

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4110

---

Explain transaction control transformation in informatica

1269

---

What are the guidelines to be followed while using union transformation?

1144

---

Explain target update override in informatica

1126

---

Define the various join types of joiner transformation?

988

---

Briefly define reusable transformation?

1131

---

what is degenerated dimension?

3998

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554

---

what are the deliverables?in your project?

2152

---