Answer Posted / prasad

Hi,

This is prasad,
Please send me the dump to prasad_svn84@yahoo.com

What does update strategy mean, and what are the different option of it?

1038

---

what is diff b/t sorter t/r and agg have the option sorter property...

2133

---

What is a standalone command task?

1142

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2802

---

What do you mean by blocking transformation?

972

---

How can we improve session performance in aggregator transformation?

1042

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1197

---

What is meant by target load plan?

916

---

What is aggregate cache in aggregator transformation?

1067

---

Explain in detail about scd type 1 through mapping.

1300

---

How to differentiate between the active and passive transformations?

1078

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1888

---

What is confirmed fact in dataware housing?

6805

---

update strategy transformation in informatica

1017

---

Target increases every day even though no new record was inserted

1516

---