Answer Posted / souvik

We need to have a Lookup with a Dynamic Cache, a Router, an Expression and then an Update Strategy..... The Lookup will be on the Target Table..... So when the ID is coming for the first time, it wont found any data on the lookup table.... This can be directed for Insertion to the Target Table via a Router.... Then when the same ID is coming for the second time, it will Lookup on the Target Table and will found that the row with the ID exists.... Hence both the columns from the source table and both the columns from the Lookup are taken forward into the Router and then to an Expression Transformation where the second port is Concatenated. Then the ID port and this port is taken to the Update Strategy transformation for Update...

what are factless facts? And in which scenario will you use such kinds of fact tables.

1738

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1985

---

What is mapping debugger?

941

---

How to partition the Session?

1039

---

Explain incremental aggregation in informatica

1063

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1038

---

What is a sorter transformation?

1033

---

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

1194

---

Enlist the differences between database and data warehouse.

1032

---

What is Index Caches size?

1053

---

can u give example for factless fact table

6440

---

How to start a workflow using pmcmd command?

1171

---

What is the Rank index port in Rank transformation?

1011

---

Can we get 1st record through Informatica(without sequence number).

1402

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1973

---